public void DoView() { if (string.IsNullOrEmpty(Purid)) return; var bl = new Blpurretinv { Retinvid = Purid }; bl.GetPurRetinv(); txtpurno.Text = Purid; LookupSupplier.EditValue = bl.Supid == "0" ? null : bl.Supid; invno.EditValue = bl.Invno; invdate.EditValue = bl.Invdate; duedays.EditValue = bl.Duedays; spdisc.EditValue = bl.Spdiscount; adjustval.EditValue = bl.Adjvalue; ShorcutKeysDisbale = !bl.Hold; Lookupwarehouse.EditValue = null; Lookupwarehouse.EditValue = bl.Whid; if (dsPurchase1.RETURNDETAIL.Rows.Count > 0) { dsPurchase1.RETURNDETAIL.Clear(); Functions.DeleteBackUp(); dsPurchase1.Merge(bl.Retinvdetail); } else { dsPurchase1.Merge(bl.Retinvdetail); } UpdateTotals(); }
//string GetBarCodeFromQuery(IEnumerable<DataRow> qry) //{ // DataTable tb = qry.CopyToDataTable<DataRow>(); // return tb.Rows[0]["BARCODE"].ToString(); //} bool DoSave() { bool retval = false; if (!IsHold) { PurchaseInvoceHasErrors(); ValidateStock(); if(dsPurchase1.PURINVDETAIL.HasErrors) { XtraMessageBox.Show("Invoice not saved due to error, please check the errors", "POS", MessageBoxButtons.OK, MessageBoxIcon.Error); return false; } } UpdateTotals(); var dr = (DsPurchase.RETURNMASTRow)dsPurchase1.RETURNMAST.NewRow(); if (!string.IsNullOrEmpty(Purid)) dr.RETURNID = Purid; dr.COMPANY = Utils.Company; dr.SUPID = LookupSupplier.EditValue == null ? null : LookupSupplier.EditValue.ToString(); dr.SUPNAME = string.IsNullOrWhiteSpace(LookupSupplier.Text) ? null : LookupSupplier.Text; dr.INVNO = invno.EditValue == null ? null : invno.EditValue.ToString(); dr.INVDATE = invdate.DateTime; dr.SPDISCOUNT = spdisc.EditValue == null ? 0 : decimal.Parse(spdisc.EditValue.ToString()); dr.ADJVALUE = adjustval.EditValue == null ? 0 : decimal.Parse(adjustval.EditValue.ToString()); dr.NETVALUE = totnetamt.EditValue == null ? 0 : decimal.Parse(totnetamt.EditValue.ToString()); dr.WHID = Lookupwarehouse.EditValue == null ? string.Empty : Lookupwarehouse.EditValue.ToString(); dr.HOLD = IsHold; dr.USERID = Utils.Userid; var bhl = new Blpurretinv(dr); advBandedGridView1.PostEditor(); advBandedGridView1.UpdateCurrentRow(); rETURNDETAILBindingSource.EndEdit(); var changes = (DsPurchase.RETURNDETAILDataTable)dsPurchase1.RETURNDETAIL.GetChanges(DataRowState.Modified | DataRowState.Added); bhl.Retinvdetail = dsPurchase1.RETURNDETAIL; try { var strstatus = bhl.DoSave(); if (strstatus == "1") { Purid = bhl.Retinvid; txtpurno.Text = Purid; RibbonSaveEnable = false; HoldButtonVisibility = BarItemVisibility.Never; XtraMessageBox.Show("Data Saved Sucessfully", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information); foreach (DataRow d in dsPurchase1.RETURNDETAIL.Rows) { if (d.RowState != DataRowState.Deleted) { d["RETURNID"] = bhl.Retinvid; } } var addedRows = from row in dsPurchase1.RETURNDETAIL where row.RowState == DataRowState.Added select row; foreach (var row in addedRows.ToArray()) { row.Delete(); } if (changes != null) dsPurchase1.Merge(changes); dsInventory1.AcceptChanges(); Functions.DeleteBackUp(); retval = true; } else { XtraMessageBox.Show(strstatus); } } catch (Exception ex) { Functions.CreateBackUp(dsPurchase1.RETURNDETAIL); XtraMessageBox.Show(ex.ToString()); } SaveRequired = !retval; return retval; }