private void FillFormData()
{
using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
LinqQueryForTrudoyomkost.FillInfProductsList(currentContext, ref FillTrudoyomkostDB.infProductList);
LinqQueryForTrudoyomkost.FillLabourNormList(currentContext, ref FillTrudoyomkostDB.LabourNormList);
LinqQueryForTrudoyomkost.FillWhereOperationUseList(currentContext, ref FillTrudoyomkostDB.WhereOperationUseList);
_whereUseList = LinqQueryForTrudoyomkost.FillWhereUselst(currentContext);
_depList = LinqQueryForTrudoyomkost.FillinfDeplst(currentContext);
_infDetList = LinqQueryForTrudoyomkost.FillinfDetList(currentContext);
FillTrudoyomkostDB.whereUseList = _whereUseList;
FillTrudoyomkostDB.infDetList = _infDetList;
LinqQueryForTrudoyomkost.FilldcInfProducts(currentContext, ref FillTrudoyomkostDB.DcInfProducts);
_infProductsDc = FillTrudoyomkostDB.DcInfProducts;
LinqQueryForTrudoyomkost.FilldcDetNumForProduct(ref dcIDDetNum, _infProductsDc.Values.First());
LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf);
LinqQueryForTrudoyomkost.GetInfTariffList(currentContext, ref FillTrudoyomkostDB.tariffList);
LinqQueryForTrudoyomkost.FillDictDepIDCode(currentContext, ref FillTrudoyomkostDB.DicDepCodeAndId);
_detNumList.Clear();
foreach (var item in dcIDDetNum)
{
_detNumList.Add(item.Key);
}
}//
}
private void btDelProf_Click(object sender, EventArgs e)
{
if (
MessageBox.Show("Вы уверены, что хотите удалить запись?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
FillTrudoyomkostDB.InfProfessionTableAdapter.DeleteRow(_currentProfCode);
using (
var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf);
}
}
}
private void btProfAdd_Click_1(object sender, EventArgs e)
{
foreach (DataRow row in _dtInfProf.Rows)
{
if ((int)row[0] == int.Parse(vtbProfCode.ValueTxt))
{
return;
}
}
if (checkValidateProfRow(gpEditProff))
{
using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
FillTrudoyomkostDB.InfProfessionTableAdapter.InsertQuery(int.Parse(vtbProfCode.ValueTxt),
tbProfName.Text, tbProfKindWork.Text, 1049);
LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf);
}
errorProv.SetError(gpEditProff, String.Empty);
}
else
{
errorProv.SetError(gpEditProff, "Заполните поля");
}
}
