public void execute() { using (var currentContex = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { FillTrudoyomkostDB.WhereOperationUseList.Add(_whereOperUse); currentContex.WhereOperationUse.InsertOnSubmit(_whereOperUse); currentContex.SubmitChanges(); } }
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(); } } } }
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(); } }