using System;
using System.Collections .Generic ;
using System.ComponentModel ;
using System.Data ;
using System.Drawing ;
using System.Linq ;
using System.Text ;
using System.Threading .Tasks ;
using System.Windows .Forms ;
namespace Sfera_CRM
{
public partial class AddContractsFRM : Form
{
public AddContractsFRM( )
{
InitializeComponent( ) ;
}
private void Back_Click( object sender, EventArgs e)
{
Config.forms [ "menuFRM" ] .Show ( ) ;
Hide( ) ;
}
private void AddContractsFRM_Load( object sender, EventArgs e)
{
// TODO: данная строка кода позволяет загрузить данные в таблицу "crmDB_resDataSet.Workers". При необходимости она может быть перемещена или удалена.
this.workersTableAdapter .Fill ( this.crmDB_resDataSet .Workers ) ;
// TODO: данная строка кода позволяет загрузить данные в таблицу "crmDB_resDataSet.Clients". При необходимости она может быть перемещена или удалена.
this.clientsTableAdapter .Fill ( this.crmDB_resDataSet .Clients ) ;
manager.SelectedValue = Config.user_id ;
}
private void Add_Click( object sender, EventArgs e)
{
Mapping mp = new Mapping( ) ;
string sql_query = String.Format ( "INSERT INTO Contracts VALUES ({0}, {1}, {2}, {3}, N'{4}', Null)" ,
client.SelectedValue ,
manager.SelectedValue ,
DateTime.Now .ToString ( "dd-MM-yyyy" ) ,
0 ,
contract.SelectedItem .ToString ( )
) ;
mp.CRUD ( sql_query) ;
MessageBox.Show ( "Договор добавлен в CRM" ) ;
Config.forms [ "menuFRM" ] .Show ( ) ;
Hide( ) ;
}
private void manager_SelectedIndexChanged( object sender, EventArgs e)
{
if ( Config.right == "0" && manager.SelectedValue .ToString ( ) != Config.user_id )
{
MessageBox.Show ( "Только старший менеджер или управляющий может назначать договора другим менеджерам" ) ;
manager.SelectedValue = Config.user_id ;
}
}
}
}
dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLkNvbXBvbmVudE1vZGVsOwp1c2luZyBTeXN0ZW0uRGF0YTsKdXNpbmcgU3lzdGVtLkRyYXdpbmc7CnVzaW5nIFN5c3RlbS5MaW5xOwp1c2luZyBTeXN0ZW0uVGV4dDsKdXNpbmcgU3lzdGVtLlRocmVhZGluZy5UYXNrczsKdXNpbmcgU3lzdGVtLldpbmRvd3MuRm9ybXM7CgpuYW1lc3BhY2UgU2ZlcmFfQ1JNCnsKICAgIHB1YmxpYyBwYXJ0aWFsIGNsYXNzIEFkZENvbnRyYWN0c0ZSTSA6IEZvcm0KICAgIHsKICAgICAgICBwdWJsaWMgQWRkQ29udHJhY3RzRlJNKCkKICAgICAgICB7CiAgICAgICAgICAgIEluaXRpYWxpemVDb21wb25lbnQoKTsKICAgICAgICB9CgogICAgICAgIHByaXZhdGUgdm9pZCBCYWNrX0NsaWNrKG9iamVjdCBzZW5kZXIsIEV2ZW50QXJncyBlKQogICAgICAgIHsKICAgICAgICAgICAgQ29uZmlnLmZvcm1zWyJtZW51RlJNIl0uU2hvdygpOwogICAgICAgICAgICBIaWRlKCk7CiAgICAgICAgfQoKICAgICAgICBwcml2YXRlIHZvaWQgQWRkQ29udHJhY3RzRlJNX0xvYWQob2JqZWN0IHNlbmRlciwgRXZlbnRBcmdzIGUpCiAgICAgICAgewogICAgICAgICAgICAvLyBUT0RPOiDQtNCw0L3QvdCw0Y8g0YHRgtGA0L7QutCwINC60L7QtNCwINC/0L7Qt9Cy0L7Qu9GP0LXRgiDQt9Cw0LPRgNGD0LfQuNGC0Ywg0LTQsNC90L3Ri9C1INCyINGC0LDQsdC70LjRhtGDICJjcm1EQl9yZXNEYXRhU2V0LldvcmtlcnMiLiDQn9GA0Lgg0L3QtdC+0LHRhdC+0LTQuNC80L7RgdGC0Lgg0L7QvdCwINC80L7QttC10YIg0LHRi9GC0Ywg0L/QtdGA0LXQvNC10YnQtdC90LAg0LjQu9C4INGD0LTQsNC70LXQvdCwLgogICAgICAgICAgICB0aGlzLndvcmtlcnNUYWJsZUFkYXB0ZXIuRmlsbCh0aGlzLmNybURCX3Jlc0RhdGFTZXQuV29ya2Vycyk7CiAgICAgICAgICAgIC8vIFRPRE86INC00LDQvdC90LDRjyDRgdGC0YDQvtC60LAg0LrQvtC00LAg0L/QvtC30LLQvtC70Y/QtdGCINC30LDQs9GA0YPQt9C40YLRjCDQtNCw0L3QvdGL0LUg0LIg0YLQsNCx0LvQuNGG0YMgImNybURCX3Jlc0RhdGFTZXQuQ2xpZW50cyIuINCf0YDQuCDQvdC10L7QsdGF0L7QtNC40LzQvtGB0YLQuCDQvtC90LAg0LzQvtC20LXRgiDQsdGL0YLRjCDQv9C10YDQtdC80LXRidC10L3QsCDQuNC70Lgg0YPQtNCw0LvQtdC90LAuCiAgICAgICAgICAgIHRoaXMuY2xpZW50c1RhYmxlQWRhcHRlci5GaWxsKHRoaXMuY3JtREJfcmVzRGF0YVNldC5DbGllbnRzKTsKICAgICAgICAgICAgbWFuYWdlci5TZWxlY3RlZFZhbHVlID0gQ29uZmlnLnVzZXJfaWQ7CgogICAgICAgIH0KCiAgICAgICAgcHJpdmF0ZSB2b2lkIEFkZF9DbGljayhvYmplY3Qgc2VuZGVyLCBFdmVudEFyZ3MgZSkKICAgICAgICB7CiAgICAgICAgICAgIE1hcHBpbmcgbXAgPSBuZXcgTWFwcGluZygpOwogICAgICAgICAgICBzdHJpbmcgc3FsX3F1ZXJ5ID0gU3RyaW5nLkZvcm1hdCgiSU5TRVJUIElOVE8gQ29udHJhY3RzIFZBTFVFUyAoezB9LCB7MX0sIHsyfSwgezN9LCBOJ3s0fScsIE51bGwpIiwgCiAgICAgICAgICAgICAgICBjbGllbnQuU2VsZWN0ZWRWYWx1ZSwKICAgICAgICAgICAgICAgIG1hbmFnZXIuU2VsZWN0ZWRWYWx1ZSwKICAgICAgICAgICAgICAgIERhdGVUaW1lLk5vdy5Ub1N0cmluZygiZGQtTU0teXl5eSIpLAogICAgICAgICAgICAgICAgMCwKICAgICAgICAgICAgICAgIGNvbnRyYWN0LlNlbGVjdGVkSXRlbS5Ub1N0cmluZygpCiAgICAgICAgICAgICAgICApOwoKICAgICAgICAgICAgbXAuQ1JVRChzcWxfcXVlcnkpOwogICAgICAgICAgICBNZXNzYWdlQm94LlNob3coItCU0L7Qs9C+0LLQvtGAINC00L7QsdCw0LLQu9C10L0g0LIgQ1JNIik7CiAgICAgICAgICAgIENvbmZpZy5mb3Jtc1sibWVudUZSTSJdLlNob3coKTsKICAgICAgICAgICAgSGlkZSgpOwoKCgoKICAgICAgICB9CgogICAgICAgIHByaXZhdGUgdm9pZCBtYW5hZ2VyX1NlbGVjdGVkSW5kZXhDaGFuZ2VkKG9iamVjdCBzZW5kZXIsIEV2ZW50QXJncyBlKQogICAgICAgIHsKICAgICAgICAgICAgaWYgKENvbmZpZy5yaWdodCA9PSAiMCIgJiYgbWFuYWdlci5TZWxlY3RlZFZhbHVlLlRvU3RyaW5nKCkgIT0gQ29uZmlnLnVzZXJfaWQpCiAgICAgICAgICAgIHsKICAgICAgICAgICAgICAgIE1lc3NhZ2VCb3guU2hvdygi0KLQvtC70YzQutC+INGB0YLQsNGA0YjQuNC5INC80LXQvdC10LTQttC10YAg0LjQu9C4INGD0L/RgNCw0LLQu9GP0Y7RidC40Lkg0LzQvtC20LXRgiDQvdCw0LfQvdCw0YfQsNGC0Ywg0LTQvtCz0L7QstC+0YDQsCDQtNGA0YPQs9C40Lwg0LzQtdC90LXQtNC20LXRgNCw0LwiKTsKICAgICAgICAgICAgICAgIG1hbmFnZXIuU2VsZWN0ZWRWYWx1ZSA9IENvbmZpZy51c2VyX2lkOwogICAgICAgICAgICB9CiAgICAgICAgfQogICAgfQp9Cg==
compilation info
prog.cs(4,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing `System.Data' assembly reference?
prog.cs(9,22): error CS0234: The type or namespace name `Forms' does not exist in the namespace `System.Windows'. Are you missing `System.Windows.Forms' assembly reference?
prog.cs(13,44): error CS0246: The type or namespace name `Form' could not be found. Are you missing an assembly reference?
Compilation failed: 3 error(s), 0 warnings
stdout