public void execute()
{
var result = from currLabItem in FillTrudoyomkostDB.CurrentLabourNormList
join whOper in FillTrudoyomkostDB.WhereOperationUseList
on currLabItem.ID equals whOper.LabourNormID
select new
{
LabourId= currLabItem.ID,
whOper.Id,
whOper.InfProductsChipher,
whOper.SeriaFrom,
whOper.SeriaTo,
} into res
group res by res.LabourId
into groupResult
select new
{
Key = groupResult.Key,
Value = groupResult
};
using (var currentContex = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
foreach (var item in result)
{
if (item.Value.Count() < 2)
{
var tempEl= item.Value.First();
if (tempEl.SeriaFrom >= _seriaFrom && tempEl.InfProductsChipher == _productCipher)
{
var el= currentContex.WhereOperationUse.First(x => x.Id == tempEl.Id);
var memoryEl = FillTrudoyomkostDB.WhereOperationUseList.First(x => x.Id == tempEl.Id);
bool Visible = FillTrudoyomkostDB.WhereOperationUseList.Remove(memoryEl);
currentContex.WhereOperationUse.DeleteOnSubmit(el);
}
else if(tempEl.SeriaFrom < _seriaFrom && tempEl.SeriaTo >=_seriaFrom && tempEl.InfProductsChipher ==_productCipher)
{
var el = currentContex.WhereOperationUse.First(x => x.Id == tempEl.Id);
el.SeriaTo = _seriaFrom - 1;
FillTrudoyomkostDB.WhereOperationUseList.First(x => x.Id == tempEl.Id).SeriaTo = _seriaFrom - 1;
}
currentContex.SubmitChanges();
}
}
}
}
public void execute()
{
using (var currentContex = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
FillTrudoyomkostDB.WhereOperationUseList.Add(_whereOperUse);
currentContex.WhereOperationUse.InsertOnSubmit(_whereOperUse);
currentContex.SubmitChanges();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
foreach (var item in currentContext.LabourNorm)
{
if (item.ItemCTN == 0 && item.PreparTimeCTN == 0 && item.ItemPayNorm == 0 && item.PreparTimePayNorm == 0)
{
currentContext.LabourNorm.DeleteOnSubmit(item);
}
if (item.KindPay == "C")
item.KindPay = "C";
currentContext.SubmitChanges();
}
}
}
private void dgProducts_RowValidated(object sender, DataGridViewCellEventArgs e)
{
short cipher = 0;
DataGridView tempDg;
tempDg = sender as DataGridView;
if (tempDg != null)
cipher = (short)tempDg.Rows[e.RowIndex].Cells[0].Value;
//tempDg.Rows[e.RowIndex].
using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
var selectEntity = currentContext.InfProducts.Where(item => item.Cipher == cipher).First();
selectEntity.Product = tempDg.Rows[e.RowIndex].Cells[1].Value.ToString();
selectEntity.Mask = (byte)tempDg.Rows[e.RowIndex].Cells[3].Value;
selectEntity.ProductTotal = tempDg.Rows[e.RowIndex].Cells[2].Value.ToString();
currentContext.SubmitChanges();
}
}
private void btSaveAndLimit_Click(object sender, EventArgs e)
{
CheckValidateForm(gbOperItems);
if (!IsValidForm)
{
MessageBox.Show(_isValidateGbNotific);
IsValidForm = true;
return;
}
using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString))
{
foreach (var item in _oldAndNewApplyDict)
{
WhereOperationUse tempItem = new WhereOperationUse();
tempItem = FillTrudoyomkostDB.WhereOperationUseList.ToList().Find(currItem => (currItem.SeriaFrom == item.Key.SeriaFrom && currItem.SeriaTo == item.Key.SeriaTo && currItem.InfProductsChipher == item.Key.ProductChipher && currItem.LabourNormID == templabour.ID));
tempItem.SeriaTo = item.Value.SeriaFrom - 1;
FillTrudoyomkostDB.WhereOperationUseTableAdapter.UpdateSeriaTo(tempItem.SeriaTo, item.Key.ProductChipher, item.Key.SeriaFrom, templabour.ID);
FillTrudoyomkostDB.WhereOperationUseList.Add(item.Value);
currentContext.WhereOperationUse.InsertOnSubmit(item.Value);
currentContext.SubmitChanges();
}
templabour.ID = _newID;
btSaveAndLimit.Enabled = false;
UpdateLabourNorm(ref templabour, _timeInHour);
FillTrudoyomkostDB.LabourNormTableAdapter.InsertQuery(templabour.InfDetID, templabour.OperNum, templabour.DepRegion, templabour.ProfCode, templabour.NameKindWork,
templabour.TariffNetNum, templabour.KindPay, templabour.WorkerRate, templabour.ItemCTN, templabour.PreparTimeCTN,
templabour.ItemPayNorm, templabour.PreparTimePayNorm, templabour.Valuation, templabour.ValPreparTime, templabour.CoeffCTN, templabour.DocNum, templabour.Date, templabour.TaskNumber);
FillTrudoyomkostDB.LabourNormList.Add(templabour);
templabour = new LabourNorm();
}
_parentForm.UpdateDataGrids();
_newID++;
btSaveAndLimit.Enabled = true;
}