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);
}
