int CountInvoiceNo() { var t = 0; if (invno.EditValue != null) { var ta = new DataSet1TableAdapters.PURINVMAINTableAdapter(); if (!string.IsNullOrEmpty(_purid)) { var invoiceCountWithHold = ta.GetInvoiceCountWithHold(supplier.EditValue.ToString(), invno.EditValue.ToString(), _purid); if (invoiceCountWithHold != null) t = (int)invoiceCountWithHold; } else { var invoiceCount = ta.GetInvoiceCount(supplier.EditValue.ToString(), invno.EditValue.ToString()); if (invoiceCount != null) t = (int)invoiceCount; } } return t; }
void DoSave() { var Errorlist = new ArrayList(); c1TrueDBGrid1.UpdateData(); if (supplier.EditValue==null) { _ishold = false; XtraMessageBox.Show("Please select the supplier","P.O.S",MessageBoxButtons.OK,MessageBoxIcon.Information); return; } if (warehouse.EditValue == null) { _ishold = false; XtraMessageBox.Show("Please select the warehouse name", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DateTime? dtinv = null; if (invdate.EditValue == null || invdate.EditValue.ToString()==string.Empty) dtinv = null; else dtinv = (DateTime?)invdate.EditValue; string Inv=""; if (invno.EditValue == null) Inv=string.Empty; else Inv = (string)invno.EditValue; if (!_ishold) { if (invno.EditValue==null) { XtraMessageBox.Show("Please enter the invoice no", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (invdate.EditValue == null) { XtraMessageBox.Show("Please enter the invoice date", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } foreach (var d in this.dataSet1.PURINVDETAIL) { string t = ""; if (int.Parse(d["qty"].ToString()) == 0) { t = "Quantity not found for item :" + GetItemname(d["ITEMID"].ToString()); Errorlist.Add(t); } if (decimal.Parse(d["invrate"].ToString()) == 0) { t = "Inv.Rate not found for item :" + GetItemname(d["ITEMID"].ToString()); Errorlist.Add(t); } if (decimal.Parse(d["sprice"].ToString()) == 0) { t = "Sales price not found for item : " + GetItemname(d["ITEMID"].ToString()); Errorlist.Add(t); } if (bool.Parse(d["expr"].ToString()) == true && string.IsNullOrEmpty(d["expdate"].ToString())) { t = "Expiry date not found for item :" + GetItemname(d["ITEMID"].ToString()); Errorlist.Add(t); } } } if (CountInvoiceNo() > 0) { XtraMessageBox.Show("Duplicate invoice no found..!,please check the invoice no", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (Errorlist.Count > 0) { var f = new Testing(Errorlist); f.ShowDialog(); return; } Whid = warehouse.EditValue==null ? 0 : int.Parse(warehouse.EditValue.ToString()); try { if (!string.IsNullOrEmpty(_purid)) { _issaved = true; var dr = this.dataSet1.PURINVMAIN.FindByPURINVID(_purid); if (dr != null) { dr.BeginEdit(); dr.SUPID = supplier.EditValue.ToString(); dr.SUPNAME = supplier.Text; dr.INVNO = Inv; if(dtinv==null) dr["INVDATE"] = DBNull.Value; else dr["INVDATE"] = dtinv; dr.DUEDAYS = int.Parse(duedays.EditValue.ToString()); dr.SPDISCOUNT = decimal.Parse(spdisc.EditValue.ToString()); dr.ADJVALUE = decimal.Parse(adjustval.EditValue.ToString()); dr.HOLD = _ishold; dr.WHID = Whid; dr.EUSERID = COMMON.Utils.Userid; dr.EDATE = DateTime.Now; dr.NETVALUE = decimal.Parse(netamt.EditValue.ToString()); dr.EndEdit(); this.purinvmainTableAdapter1.Update(dr); } } else { var InsertQ = new DataSet1TableAdapters.PURINVMAINTableAdapter(); //_purid = Convert.ToInt32(InsertQ.InsertQuery(DateTime.Today.Date, // supplier.EditValue.ToString(), // supplier.Text, // Inv, // dtinv, // int.Parse(duedays.EditValue.ToString()), // decimal.Parse(spdisc.EditValue.ToString()), // decimal.Parse(adjustval.EditValue.ToString()), // _ishold, // Whid, // 0, // COMMON.Utils.Userid, // DateTime.Now, // 0, // null,decimal.Parse(netamt.EditValue.ToString())).ToString()); } if (!string.IsNullOrEmpty(_purid)) { purno.EditValue = _purid; _issaved = true; foreach (DataRow d in this.dataSet1.PURINVDETAIL.Rows) { d["PURINVID"] = _purid; } pURINVDETAILTableAdapter1.Update(this.dataSet1.PURINVDETAIL); if (_ishold) { XtraMessageBox.Show("Invoice holded sucessfully", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { UpdateStock(); XtraMessageBox.Show("Invoice recorded sucessfully", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { XtraMessageBox.Show("Error while saving please try again", "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show(ex.ToString(), "P.O.S", MessageBoxButtons.OK, MessageBoxIcon.Information); } }