private void button1_Click(object sender, EventArgs e) { if (0 < commonFunctions.ToDecimal(txt_qtyremain.Text.Trim())) { errorProvider1.SetError(txt_fullqty, "You must allocate full amount for the selected customer."); commonFunctions.SetMDIStatusMessage("You must allocate full amount for the selected customer.", 1); return; } if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { try { T_SalesAllocHead alloc = new T_SalesAllocHead(); alloc.Docno = selecteddoc; alloc = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(alloc); decimal cumilative = decimal.Zero; foreach (DataGridViewRow drow in dgcustomer.Rows) { cumilative = commonFunctions.ToDecimal(drow.Cells[2].Value.ToString()); T_SalesAllocDet objt_SalesAllocDet = new T_SalesAllocDet(); objt_SalesAllocDet.Docno = selecteddoc; objt_SalesAllocDet.SalesMan = alloc.Salesman; objt_SalesAllocDet.Customer = drow.Cells[0].Value.ToString(); objt_SalesAllocDet.Item = alloc.Item; objt_SalesAllocDet.AllowedQTY = alloc.AllocQTY; objt_SalesAllocDet.AllocQTY = commonFunctions.ToDecimal(cumilative.ToString()); objt_SalesAllocDet.DateFrom = alloc.DateFrom.Value; objt_SalesAllocDet.Dateto = alloc.Dateto.Value; objt_SalesAllocDet.Userx = commonFunctions.Loginuser; objt_SalesAllocDet.Datex = DateTime.Now; T_SalesAllocDetDL bal = new T_SalesAllocDetDL(); bal.Savet_SalesAllocDetSP(objt_SalesAllocDet, 1); } LoadDataSavedALLOCATIONS(); } catch (Exception ex) { } } }
private void dgsaved_RowsRemoved_1(object sender, DataGridViewRowsRemovedEventArgs e) { try { T_SalesAllocDet det = new T_SalesAllocDet(); det.Docno = dcomming.Cells[0].Value.ToString(); det.SalesMan = dcomming.Cells[1].Value.ToString(); det.Customer = dcomming.Cells[2].Value.ToString(); det = new T_SalesAllocDetDL().Selectt_SalesAllocDet(det); ////new T_SalesAllocDetDL().Savet_SalesAllocDetSP(det, 4); ////LoadDataSavedALLOCATIONS(); //if ((dgsaved.SelectedRows.Count == 0) || ((dgsaved.SelectedRows.Count == 1) && (dgsaved.SelectedRows[0].IsNewRow))) //{ // MessageBox.Show("Set of rows deleted" + dgsaved.SelectedRows[0].Cells[2].Value.ToString()); //} } catch (Exception ex) { } }
private void button3_Click(object sender, EventArgs e) { try { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { string x = dgsaved.SelectedRows[0].Cells[0].Value.ToString(); T_SalesAllocDet det = new T_SalesAllocDet(); det.Docno = x.ToString(); List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>(); dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det); foreach (T_SalesAllocDet de in dets) { new T_SalesAllocDetDL().Savet_SalesAllocDetSP(de, 4); } LoadDataSavedALLOCATIONS(); UserDefineMessages.ShowMsg1("All allocation breakdown Detleted for header allocation NO: " + x, UserDefineMessages.Msg_Information); } } catch (Exception ex) { } }
private void btn_save_Click(object sender, EventArgs e) { try { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { if (dgsaved.SelectedRows.Count > 0) { bool exists = false; List <string> itemsx = new List <string>(); foreach (DataGridViewRow rowx in dgsaved.SelectedRows) { string x = rowx.Cells[0].Value.ToString(); T_SalesAllocDet det = new T_SalesAllocDet(); det.Docno = x.ToString(); List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>(); dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det); if (dets.Count > 0) { itemsx.Add(x); exists = true; } else { T_SalesAllocHead head = new T_SalesAllocHead(); head.Docno = rowx.Cells[0].Value.ToString(); head = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(head); new T_SalesAllocHeadDL().Savet_SalesAllocHeadSP(head, 4); } } GetAllocations(selectedsalesman); if (exists == true) { string numbers = ""; foreach (string x in itemsx) { numbers += "\n" + x; } UserDefineMessages.ShowMsg1("Selected Allocation headers deleted except these " + numbers + " \nbecouse they have breakdowns", UserDefineMessages.Msg_Warning); } else { UserDefineMessages.ShowMsg1("Selected Allocation headers were deleted ", UserDefineMessages.Msg_Information); } } else { string x = dgsaved.SelectedRows[0].Cells[0].Value.ToString(); T_SalesAllocDet det = new T_SalesAllocDet(); det.Docno = x.ToString(); List <T_SalesAllocDet> dets = new List <T_SalesAllocDet>(); dets = new T_SalesAllocDetDL().SelectT_SalesAllocDetMulti(det); if (dets.Count > 0) { UserDefineMessages.ShowMsg1("Cannot delete the allocation master: " + x + ". becouse it has breakdowns ", UserDefineMessages.Msg_Warning); } else { T_SalesAllocHead head = new T_SalesAllocHead(); head.Docno = dgsaved.SelectedRows[0].Cells[0].Value.ToString(); head = new T_SalesAllocHeadDL().Selectt_SalesAllocHead(head); new T_SalesAllocHeadDL().Savet_SalesAllocHeadSP(head, 4); GetAllocations(selectedsalesman); UserDefineMessages.ShowMsg1("Allocation header detleted NO: " + x, UserDefineMessages.Msg_Information); } } } } catch (Exception ex) { } }