//Редактирование записи таблицы ASSISTANCE
private void ASCE_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ AssistanceFileds.ASCE_Code.Name(), ASCE_HelpCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ AssistanceFileds.ASCE_AssCode.Name(), ASCE_AssistantCB.SelectedValue.ToString() },
{ AssistanceFileds.ASCE_OrdCode.Name(), ASCE_OrderCB.SelectedValue.ToString() }
});
RefreshControls();
}
//Редактирование записи таблицы ASSISTANTS
private void ASS_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Code.Name(), ASS_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Fullname.Name(), ASS_FullnameTB.Text },
{ AssistantsFileds.ASS_Phone.Name(), ASS_PhoneMTB.Text },
{ AssistantsFileds.ASS_Salary.Name(), ASS_SalaryTB.Text }
});
RefreshControls();
}
//Редактирование записи таблицы CUSTOMERS
private void CUS_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ CustomerFields.CUS_Code.Name(), CUS_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ CustomerFields.CUS_Fullname.Name(), CUS_FullnameTB.Text },
{ CustomerFields.CUS_Adress.Name(), CUS_AdressTB.Text },
{ CustomerFields.CUS_Phone.Name(), CUS_PhoneMTB.Text },
});
RefreshControls();
}
//Редактирование записи таблицы ORDERS
private void ORD_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ OrdersFileds.ORD_Code.Name(), ORD_OrderCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ OrdersFileds.ORD_CusCode.Name(), ORD_CustomersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_PhoCode.Name(), ORD_PhotographersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_SerCode.Name(), ORD_ServicesCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_Date.Name(), ORD_DateMTB.Text },
{ OrdersFileds.ORD_Exec.Name(), Convert.ToInt32(ORD_ExecCB.Checked).ToString() }
});
RefreshControls();
}
//Редактирование записи таблицы PHOTOGRAPHERS
private void PHO_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Code.Name(), PHO_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Fullname.Name(), PHO_FullnameTB.Text },
{ PhotographersFileds.PHO_Experience.Name(), PHO_ExperienceTB.Text },
{ PhotographersFileds.PHO_Date.Name(), PHO_DateMTB.Text },
{ PhotographersFileds.PHO_Phone.Name(), PHO_PhoneMTB.Text },
{ PhotographersFileds.PHO_Adress.Name(), PHO_AdressTB.Text },
{ PhotographersFileds.PHO_Salary.Name(), PHO_SalaryTB.Text }
});
RefreshControls();
}