private void btnAdd_Click(object sender, EventArgs e) { string name = tbName.Text; int group = cmbGroup.SelectedIndex + 1; double baserate = System.Convert.ToDouble(tbBaseRate.Text); DateTime datestart = datePickerDateStart.Value; int?parent_id = (int)cmbBosses.SelectedValue; if ((int)cmbBosses.SelectedValue == 0) { parent_id = null; } try { STDemoSqlData.InsertEmployeeInDataBase(name, group, baserate, datestart, parent_id); } catch (Exception ex) { MessageBox.Show(string.Format("Error adding data:{0}", ex.Message)); } BindNewDataToGridView(); MessageBox.Show("Данные успешно добавлены."); }
private void MainForm_Load(object sender, EventArgs e) { try { STDemoSqlData.CreateDemoDataBase(); RefreshData(); LoadComboBoxBossesData(); } catch (Exception ex) { MessageBox.Show(string.Format("Error loading data:{0}", ex.Message)); } }
private void RefreshData() { STSysTechEmployeesData.AllEmployees.Clear(); DataTable dt = STDemoSqlData.GetDataFromDataBase(); List <STSysTechEmployee> employees = (from d in dt.AsEnumerable() where (d.Field <Int64>("group") == 1) select new STEmployee() { ID = Convert.ToInt32(d["id"]), Name = d["name"].ToString(), Group = Convert.ToInt32(d["group"]), BaseRate = Convert.ToDouble(d["baserate"]), DateStart = Convert.ToDateTime(d["datestart"]), ParentId = ConvertNullableInt(d["parent_id"]) }).ToList <STSysTechEmployee>(); STSysTechEmployeesData.AddEmployees(employees); List <STSysTechEmployee> managers = (from d in dt.AsEnumerable() where (d.Field <Int64>("group") == 2) select new STManager() { ID = Convert.ToInt32(d["id"]), Name = d["name"].ToString(), Group = Convert.ToInt32(d["group"]), BaseRate = Convert.ToDouble(d["baserate"]), DateStart = Convert.ToDateTime(d["datestart"]), ParentId = ConvertNullableInt(d["parent_id"]) }).ToList <STSysTechEmployee>(); STSysTechEmployeesData.AddEmployees(managers); List <STSysTechEmployee> salesmans = (from d in dt.AsEnumerable() where (d.Field <Int64>("group") == 3) select new STSalesMan() { ID = Convert.ToInt32(d["id"]), Name = d["name"].ToString(), Group = Convert.ToInt32(d["group"]), BaseRate = Convert.ToDouble(d["baserate"]), DateStart = Convert.ToDateTime(d["datestart"]), ParentId = ConvertNullableInt(d["parent_id"]) }).ToList <STSysTechEmployee>(); STSysTechEmployeesData.AddEmployees(salesmans); }