public string DoSave() { var dm = new PurInvDataManager(); var retval = dm.DoSave(PurinvmainRow, Purinvdetail,isforsale, Whid); if(retval=="1") { Purinvid = Utils.Purinvid; } return retval; }
public DsMaster.TEMPBCODEPRINTDataTable CreateBarCodeTable(string purno) { var dt = new DsMaster().TEMPBCODEPRINT; var dm = new PurInvDataManager(); Purinvdetail = dm.GetPurInvDetailsById(purno); foreach (DataRow dr in Purinvdetail.Rows) { var dnew = dt.NewRow(); dnew["ITEMCODE"] = dr["itemno"]; dnew["ITEMNAME"] = new BlItemMaster().GetItemname(dr["itemno"].ToString()); var _qty = int.Parse(dr["qty"].ToString()) + (string.IsNullOrEmpty(dr["BONUSQTY"].ToString()) ? 0 : int.Parse(dr["BONUSQTY"].ToString())); dnew["QTY"] = _qty; dnew["PRICE"] = dr["SPRICE"]; dt.Rows.Add(dnew); } return dt; }
public void GetPurinv() { var dm = new PurInvDataManager(); var ds = ClsGetData.GetPurchaseInvByid(Purinvid); foreach (DataRow d in ds.Rows) { Supid = d["SUPID"].ToString(); Invno = d["INVNO"].ToString(); Invdate = DateTime.Parse(d["INVDATE"].ToString()); Duedays = int.Parse(d["DUEDAYS"].ToString()); Spdiscount =decimal.Parse(d["SPDISCOUNT"].ToString()); Adjvalue = decimal.Parse(d["ADJVALUE"].ToString()); Netvalue = decimal.Parse(d["NETVALUE"].ToString()); Whid = d["WHID"].ToString(); Hold = bool.Parse(d["HOLD"].ToString()); } Purinvdetail = dm.GetPurInvDetailsById(Purinvid); //Purinvdetail = ds1.PURINVDETAIL; }
public int UpdatePurInv() { var dm = new PurInvDataManager(); return dm.DoUpdateInv(Purinvid, Supid, Supname, Invno, Invdate, Duedays); }
public static int GetLastReceived(string itemno) { var dm = new PurInvDataManager(); return dm.GetLastReceivedPurchaseQtyWithBonus(itemno, Utils.Company); }
public static void DoPrint(string purid,decimal totalsale,decimal totalcost,decimal profit) { var dm = new PurInvDataManager(); decimal pp = 0; if(totalcost > 0) pp = ((totalsale - totalcost) / totalsale) * 100; else { if (profit > 0) pp = 100; } var rpt = new PurchaseRpt { Company = Utils.Companyname, Header = "Purchase Invocie", Docno = purid, TotalSale = totalsale, TotalCost = totalcost, Profit = profit, ProfitPer = pp }; var ds = dm.RptPurchaseInv(purid, Utils.Company); rpt.DataSource = ds; var printTool = new ReportPrintTool(rpt); printTool.ShowPreview(); }
public static void DeletePurchaseInv(string purid) { var dm = new PurInvDataManager(); dm.DeletePurchaseInv(purid, Utils.Company); }
public static int CountInvoiceNo(string invno, string supplier,string purid) { var dm = new PurInvDataManager(); var t = !string.IsNullOrEmpty(purid) ? dm.GetInvoiceCountWithHold(supplier, invno, purid) : dm.GetInvoiceCount(supplier, invno); return t; }
void DoUploadPurchases() { txtstatus.Caption = "Uploading Purchases"; Application.DoEvents(); try { var dm = new PurInvDataManager(); var dt = dm.GetPurchaseInvoiceNotSync(); var syc = new RemoteSync(); // GetMasters(dt, true); // syc.DoUpLoadItems(_Purinvids, true); if (dt.Rows.Count == 0) { var drd = _dsdownload.NewRow(); drd[0] = ""; drd[1] = DateTime.Now.Date; drd[2] = "Purchase Invoice"; drd[3] = "Nothing to Upload "; _dsdownload.Rows.Add(drd); } foreach (DsPurchase.PURINVMAINRow dr in dt.Rows) { if (Utils.PingServer()) { //syc.DoUpLoadItems(dr.PURINVID, true); var drd1 = _dsdownload.NewRow(); var retval = syc.DoUpLoadItems(dr.PURINVID, true); if (retval == "1") { drd1[0] = dr.PURINVID; drd1[1] = DateTime.Now.Date; drd1[2] = "Item Master - Purchase Invoice "; drd1[3] = "Upload "; } else { drd1[0] = dr.PURINVID; drd1[1] = DateTime.Now.Date; drd1[2] = "Item Master - Purchase Invoice "; drd1[3] = "Error '" + retval + "'"; } _dsdownload.Rows.Add(drd1); // Purchase invoice var drd = _dsdownload.NewRow(); drd[0] = dr.PURINVID; drd[1] = DateTime.Now.Date; drd[2] = "Purchase Invoice"; var ret = syc.DoSavePurchaseInvoiceInRemote(dr, dm.GetPurInvDetailsById(dr.PURINVID)); if (ret == "1") { dm.UpdatedSyn(dr.PURINVID); drd[3] = "Uploaded"; } else { drd[3] = "Error " + ret; } _dsdownload.Rows.Add(drd); // Purchase invoice } else { XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch(Exception exp) { XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }