public FormReports(res.Employee _curEmpl)
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
curEmpl = _curEmpl;
InitTypes();
}
public FormEditEmplSet(res.Employee _curEmpl)
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
Employees = from emp in database.EmployeeSet select emp;
Appointments = from app in database.AppointmentSet select app;
this.curEmpl = _curEmpl;
cb_app_fill();
}
public FormEditOrder(ref res.Employee curEmpl)
{
InitializeComponent();
mode = (short)OrderMode.mode_new;
curEmployee = curEmpl;
lbl_num.Text = "Новый";
#region database context & entities filling
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
curPositions = new List<PositionForOrder>();
curOrder = res.Order.CreateOrder(-1, DateTime.Now, "Обработка", -1, -1);
Items = from it in database.ItemSet select it;
Categories = from cat in database.ItemCategorySet select cat;
#endregion
#region data sources
cb_itemType.DataSource = Categories.ToArray();
cb_itemType.DisplayMember = "name";
cb_itemType.ValueMember = "id";
DGV.DataSource = DGV_contentsT;
#endregion
#region event_bindings
cb_itemType.SelectedValueChanged += new EventHandler(btn_addPos_check);
cb_itemType.SelectedValueChanged += new EventHandler(this.cb_itemType_SelectedIndexChanged);
cb_itemDesignation.SelectedIndexChanged += new EventHandler(this.cb_itemDesignation_SelectedIndexChanged);
cb_itemDesignation.SelectedValueChanged += new EventHandler(this.num_itemCount_check);
cb_itemDesignation.SelectedValueChanged += new EventHandler(btn_addPos_check);
cb_itemDesignation.SelectedValueChanged += new EventHandler(num_itemCount_anull);
num_itemCount.ValueChanged += new EventHandler(btn_addPos_check);
num_itemCount.ValueChanged += new EventHandler(num_itemCount_ValueChanged);
btn_addItem.Click += new EventHandler(btn_addItem_Click);
btn_addItem.Click += new EventHandler(btn_rmItem_check);
btn_addItem.Click += new EventHandler(DGV_contentsT_Refill);
btn_addItem.Click += new EventHandler(this.btn_accept_check);
btn_rmItem.Click += new EventHandler(btn_rmItem_Click);
btn_rmItem.Click += new EventHandler(btn_rmItem_check);
btn_rmItem.Click += new EventHandler(DGV_contentsT_Refill);
btn_rmItem.Click += new EventHandler(this.btn_accept_check);
btn_accept.Click += new EventHandler(btn_accept_Click);
tb_Name.TextChanged += new EventHandler(this.btn_accept_check);
tb_phone.TextChanged += new EventHandler(this.btn_accept_check);
DGV.SelectionChanged += new EventHandler(btn_rmItem_check);
DGV.CellValueChanged += new DataGridViewCellEventHandler(DGV_CellValueChanged);
DGV.CellValueChanged += new DataGridViewCellEventHandler(DGV_contentsT_Refill);
DGV.DataError += new DataGridViewDataErrorEventHandler(DGV_DataError);
#endregion
}
public FormIntake(res.Item _preselectedItem)
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
FillCategories();
cb_type.SelectedValue = _preselectedItem.catID;
RefillItems();
cb_designation.SelectedValue = _preselectedItem.id;
checks(this, null);
}
public FormNewEmpl()
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
Employees = from emp in database.EmployeeSet select emp;
#region event_bindings
tb_login.TextChanged += new EventHandler(Idata_Changed);
tb_name.TextChanged += new EventHandler(Idata_Changed);
rb_ord.CheckedChanged += new EventHandler(Idata_Changed);
rb_store.CheckedChanged += new EventHandler(Idata_Changed);
#endregion
}
public FormEditEmplOne(ref res.Employee empl)
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
Employees = from emp in database.EmployeeSet select emp;
this.Empl = empl;
lbl_username.Text = Empl.login;
btn_loginChange.Enabled = false;
#region event_bindings
Empl.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(this.user_prop_changed);
database.SavingChanges += new System.EventHandler(this.database_changing);
#endregion
}
public FormIntake()
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
database.Connection.Open();
cb_type.IsAccessible = false;
cb_designation.IsAccessible = false;
btn_accept.Enabled = false;
#region events
this.cb_type.SelectedIndexChanged += new EventHandler(checks);
this.cb_designation.SelectedIndexChanged += new EventHandler(checks);
#endregion
FillCategories();
}
public FormEditCategories()
{
InitializeComponent();
#region Event Bindings
this.tb_catName.TextChanged += new System.EventHandler(this.btn_checks);
this.tb_newParamName.TextChanged += new System.EventHandler(this.btn_checks);
this.tb_newItemDesignation.TextChanged += new System.EventHandler(this.btn_checks);
this.rb_binary.CheckedChanged += new EventHandler(this.btn_checks);
this.rb_numeric.CheckedChanged +=new EventHandler(this.btn_checks);
this.rb_text.CheckedChanged += new EventHandler(this.btn_checks);
this.cb_cat.SelectedIndexChanged += new System.EventHandler(this.RefillAssociations);
this.cb_cat.SelectedIndexChanged += new System.EventHandler(this.RefillItems);
this.cb_cat.SelectedIndexChanged += new System.EventHandler(this.RefillItemParameters);
this.cb_existingItem.SelectedIndexChanged += new System.EventHandler(this.RefillItemParameters);
this.btn_accParams.Click += new EventHandler(btn_accParams_Click);
this.btn_accParams.Click += new System.EventHandler(this.RefillItemParameters);
this.btn_addPar.Click +=new EventHandler(btn_addPar_Click);
this.btn_addPar.Click += new System.EventHandler(this.RefillAssociations);
this.btn_addCat.Click += new System.EventHandler(this.btn_addCat_Click);
this.btn_addCat.Click += new System.EventHandler(this.RefillCategories);
this.btn_addItem.Click += new System.EventHandler(this.btn_addItem_Click);
this.btn_addItem.Click += new System.EventHandler(this.RefillItems);
this.btn_accItem.Click += new System.EventHandler(this.btn_accItem_Click);
this.DGV_catParameters.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.btn_checks);
this.DGV_catParameters.CellValueChanged += new DataGridViewCellEventHandler(DGV_catParameters_CellValueChanged);
this.DGV_itemParameters.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.btn_checks);
#endregion
#region context & entities
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
#endregion
InitTables();
FillPTypeSelector();
RefillCategories(null, null);
}
public FormLogin()
{
InitializeComponent();
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
try
{
#region Retrieving last user from registry
tb_login.Text = RegistryInteractor.GetFromReg("Last User");
if (tb_login.Text.ToString().Length != 0)
{
cb_remember.Checked = true;
}
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка взаимодействия с реестром");
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
#region Writing current pwd & usr to registry
Regex sep = new Regex("bin");
pwd = sep.Split(Application.ExecutablePath)[0];
if (!RegistryInteractor.SubkeyExists())
{
RegistryInteractor.CreateSubkey();
RegistryInteractor.WriteToReg("Last User", "");
}
RegistryInteractor.WriteToReg("Root Directory", pwd);
RegistryInteractor.WriteToReg("Database Directory", pwd + "DATA\\");
RegistryInteractor.WriteToReg("Reports Directory", pwd + "Reports\\");
RegistryInteractor.WriteToReg("Resource Directory", pwd + "res\\");
#endregion
#region Set proper location for DB in application config file
string connectionString = ConfigurationManager.ConnectionStrings["Model1Container"].ConnectionString.Replace("|DataDirectory|", RegistryInteractor.GetFromReg("Database Directory"));
RegistryInteractor.WriteToReg("Connection String", connectionString);
#endregion
res.Model1Container database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
if (!Directory.EnumerateFiles(RegistryInteractor.GetFromReg("Database Directory"), "STORE.mdf").Any())
{
#region Deployment
if (MessageBox.Show("Похоже, это первый запуск приложения. Создать базу данных? В неё будет занесен пока единственный пользователь admin (пароль 'admin') и категории параметров товаров по умлочанию: Наименование, Цена закупки и Цена продажи.", "Внимание", MessageBoxButtons.YesNo) == DialogResult.No)
Application.Exit();
try
{
if (database.DatabaseExists())
{
database.DeleteDatabase();
}
database.CreateDatabase();
database.SaveChanges();
res.Appointment adm = res.Appointment.CreateAppointment(0, (short)accessModifiers.acc_adm, "Полный");
database.AddToAppointmentSet(res.Appointment.CreateAppointment(0, (short)accessModifiers.acc_none, "Нет"));
database.AddToAppointmentSet(res.Appointment.CreateAppointment(0, (short)accessModifiers.acc_stock, "Склад"));
database.AddToAppointmentSet(res.Appointment.CreateAppointment(0, (short)accessModifiers.acc_ord, "Заказы"));
database.AddToAppointmentSet(adm);
res.Employee admin = res.Employee.CreateEmployee(0, "admin", "admin", "admin", 0);
admin.Appointment = adm;
database.AddToEmployeeSet(admin);
database.AddToParameterCategorySet(res.ParameterCategory.CreateParameterCategory(0, "Наименование", 1));
database.AddToParameterCategorySet(res.ParameterCategory.CreateParameterCategory(0, "Цена закупки", 2));
database.AddToParameterCategorySet(res.ParameterCategory.CreateParameterCategory(0, "Цена продажи", 2));
database.SaveChanges();
}
catch (Exception exc)
{
MessageBox.Show("Произошла ошибка при создании базы данных: \n" + exc.Message);
Application.Exit();
}
#endregion
}
FormMain formMain = new FormMain();
formMain.Hide();
Application.Run(formMain);
}
//################# IDENTIFICATION ############################
private void Login()
{
FormLogin flogin = new FormLogin();
DialogResult res = flogin.ShowDialog();
switch (res)
{
case DialogResult.OK:
this.Enabled = true;
this.curEmpl = flogin.usr;
curEmpl.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(this.user_prop_changed);
this.Text = Settings.AppTitle + " - " + curEmpl.login;
database = new res.Model1Container(RegistryInteractor.GetFromReg("Connection String"));
search_Panel_Initialization();
cb_table_Init_And_Fill();
this.Enabled = true;
this.Show();
break;
default:
MessageBox.Show("Окно авторизации было закрыто", "Ошибка авторизации");
this.Show();
break;
}
}
