private void gvPayoff_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { if (newRow != null) { newRow.PAYOFFCONTROL_TYPE_ID = 1; newRow.PAYOFFCONTROL_PAYOFFMASTER_ID = _payoffMasterId; newRow.PAYOFFCONTROL_TENSIZUP = Math.Round((Convert.ToDouble(newRow.PAYOFFCONTROL_TENUP) / payoffMaster.PAYOFFMASTER_PARAMETERCODE), 2); newRow.PAYOFFCONTROL_TOTALTENUP = newRow.PAYOFFCONTROL_QUANTITY * newRow.PAYOFFCONTROL_TENUP; newRow.PAYOFFCONTROL_TOTALTENSIZUP = newRow.PAYOFFCONTROL_QUANTITY * newRow.PAYOFFCONTROL_TENSIZUP; dbContext.PayoffControl.Add(newRow); } dbContext.SaveChanges(); newRow = null; }
private void gvControl_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete && e.Modifiers == Keys.Control) { if (MessageBox.Show("Delete row?", "Confirmation", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } GridView view = sender as GridView; int controlId = gvControl.GetNullableRowCellValue(); if (controlId == 0) { return; } dbContext.PayoffControl.Remove(dbContext.PayoffControl.Find(controlId)); dbContext.SaveChanges(); view.DeleteRow(view.FocusedRowHandle); } if (e.KeyCode == Keys.D && e.Modifiers == Keys.Control) { if (MessageBox.Show("Taşeron hakedişine aktar?", "Onay", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } GridView view = sender as GridView; int controlId = gvControl.GetNullableRowCellValue(); if (controlId == 0) { return; } var payoffControl = dbContext.PayoffControl.Find(controlId); PayoffControl newPayoffControl = payoffControl; newPayoffControl.PAYOFFCONTROL_TYPE_ID = 1; dbContext.PayoffControl.Add(newPayoffControl); dbContext.SaveChanges(); XtraMessageBox.Show("Aktarım Başarılı", "OK"); } }
private void gvPayoff_InitNewRow(object sender, InitNewRowEventArgs e) { newRow = this.gvPayoff.GetRow(e.RowHandle) as PayoffControl; }
private void btnSave_Click(object sender, EventArgs e) { if (validationResult() == true) { var selectedProject = dbContext.Project.Find(lueProject.EditValue); var payoffMaster = new PayoffMaster { PAYOFFMASTER_PROJECT_ID = selectedProject.ID, PAYOFFMASTER_PARAMETERCODE = Math.Round(((100 - selectedProject.Contract.CONTRACT_PRICECUTRATE) / 100), 3) }; dbContext.PayoffMaster.Add(payoffMaster); lueProject.EditValue = null; dbContext.SaveChanges(); var excelDatas = ExcelHelper.ReadExcel(txtFilePath.Text); foreach (var row in excelDatas) { if (row.PAYOFFDEFAULT_DEF1 != "") { var payoffdef = new PayoffDefault(); payoffdef.PAYOFFDEFAULT_DEF1 = row.PAYOFFDEFAULT_DEF1; payoffdef.PAYOFFDEFAULT_DEF2 = row.PAYOFFDEFAULT_DEF3; payoffdef.PAYOFFDEFAULT_DEF3 = row.PAYOFFDEFAULT_DEF4; payoffdef.PAYOFFDEFAULT_DEF4 = row.PAYOFFDEFAULT_DEF5; payoffdef.PAYOFFDEFAULT_DEF5 = row.PAYOFFDEFAULT_DEF6; payoffdef.PAYOFFDEFAULT_DEF6 = row.PAYOFFDEFAULT_DEF7; payoffdef.PAYOFFDEFAULT_DEF7 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF8 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF9 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF10 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF11 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF12 = row.PAYOFFDEFAULT_DEF13; payoffdef.PAYOFFDEFAULT_DEF13 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF14 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF15 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF16 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF17 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF18 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF19 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_DEF20 = row.PAYOFFDEFAULT_DEF8; payoffdef.PAYOFFDEFAULT_PAYOFFMASTER_ID = payoffMaster.ID; dbContext.PayoffDefault.Add(payoffdef); } } dbContext.SaveChanges(); foreach (var item in dbContext.PayoffDefault.Where(x => x.PAYOFFDEFAULT_PAYOFFMASTER_ID == payoffMaster.ID).ToList()) { PayoffControl payoffControlVM = new PayoffControl(); payoffControlVM.PAYOFFCONTROL_LB = item.PAYOFFDEFAULT_DEF2; payoffControlVM.PAYOFFCONTROL_ITEMNAME = item.PAYOFFDEFAULT_DEF5; payoffControlVM.PAYOFFCONTROL_UNIT = item.PAYOFFDEFAULT_DEF6; payoffControlVM.PAYOFFCONTROL_SAP = item.PAYOFFDEFAULT_DEF4; payoffControlVM.PAYOFFCONTROL_TENSIZUP = Math.Round((Convert.ToDouble(item.PAYOFFDEFAULT_DEF8) / payoffMaster.PAYOFFMASTER_PARAMETERCODE), 2); payoffControlVM.PAYOFFCONTROL_TENUP = Convert.ToDouble(item.PAYOFFDEFAULT_DEF8); payoffControlVM.PAYOFFCONTROL_QUANTITY = Convert.ToDouble(item.PAYOFFDEFAULT_DEF12); payoffControlVM.PAYOFFCONTROL_TOTALTENUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENUP; payoffControlVM.PAYOFFCONTROL_TOTALTENSIZUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENSIZUP; payoffControlVM.PAYOFFCONTROL_PAYOFFMASTER_ID = payoffMaster.ID; payoffControlVM.PAYOFFCONTROL_TYPE_ID = 0; dbContext.PayoffControl.Add(payoffControlVM); } dbContext.SaveChanges(); foreach (var item in dbContext.PayoffDefault.Where(x => x.PAYOFFDEFAULT_PAYOFFMASTER_ID == payoffMaster.ID && (x.PAYOFFDEFAULT_DEF2 == "MON" || x.PAYOFFDEFAULT_DEF2 == "DM")).ToList()) { PayoffControl payoffControlVM = new PayoffControl(); payoffControlVM.PAYOFFCONTROL_LB = item.PAYOFFDEFAULT_DEF2; payoffControlVM.PAYOFFCONTROL_ITEMNAME = item.PAYOFFDEFAULT_DEF5; payoffControlVM.PAYOFFCONTROL_UNIT = item.PAYOFFDEFAULT_DEF6; payoffControlVM.PAYOFFCONTROL_SAP = item.PAYOFFDEFAULT_DEF4; payoffControlVM.PAYOFFCONTROL_TENSIZUP = Math.Round((Convert.ToDouble(item.PAYOFFDEFAULT_DEF8) / payoffMaster.PAYOFFMASTER_PARAMETERCODE), 2); payoffControlVM.PAYOFFCONTROL_TENUP = Convert.ToDouble(item.PAYOFFDEFAULT_DEF8); payoffControlVM.PAYOFFCONTROL_QUANTITY = Convert.ToDouble(item.PAYOFFDEFAULT_DEF12); payoffControlVM.PAYOFFCONTROL_TOTALTENUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENUP; payoffControlVM.PAYOFFCONTROL_TOTALTENSIZUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENSIZUP; payoffControlVM.PAYOFFCONTROL_PAYOFFMASTER_ID = payoffMaster.ID; payoffControlVM.PAYOFFCONTROL_TYPE_ID = 1; dbContext.PayoffControl.Add(payoffControlVM); } dbContext.SaveChanges(); LoadData(); } }