public string DoSave(DsPurchase.PURINVMAINRow drow, DsPurchase.PURINVDETAILDataTable purinvdetail,bool issale=false, string tostore = "") { var dm = new DataManager(); string retval; SqlTransaction tran = null; var isnew = false; try { var cn = new SqlConnection(_constr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ds = new DsPurchase(); var dt = ds.PURINVMAIN; var taPurMain = new PURINVMAINTableAdapter(); var taPurDetail = new PURINVDETAILTableAdapter(); var taStockMaster = new STOCKMASTERTableAdapter(); var taPriceMaster = new DsMasterTableAdapters.PRICEMASTERTableAdapter(); var taItemMaster = new DsMasterTableAdapters.ITEMMASTTableAdapter(); var taapar = new LedgersTableAdapters.APARMAINTableAdapter(); var taledger = new LedgersTableAdapters.LEDGERSTableAdapter(); taPurMain.Connection.ConnectionString = _constr; taPurMain.FillByPurid(ds.PURINVMAIN, drow.PURINVID); // taPurMain.Fill(ds.PURINVMAIN); // Assaign Transaction taPurMain.AssignConnection(cn, tran); taPurDetail.AssignConnection(cn, tran); taStockMaster.AssignConnection(cn, tran); taPriceMaster.AssignConnection(cn, tran); taItemMaster.AssignConnection(cn, tran); taapar.AssignConnection(cn, tran); taledger.AssignConnection(cn, tran); var dr = dt.FindByPURINVID(drow.PURINVID); if (dr != null) { dr.BeginEdit(); } else { dr = (DsPurchase.PURINVMAINRow)dt.NewRow(); } if (string.IsNullOrEmpty(drow.PURINVID)) { var autoid = dm.GetAutoId(1); autoid++; Utils.Purinvid = dm.CreateFormatedAutoNo(autoid); dr.PURINVID = Utils.Purinvid; dr.USERID = Utils.Userid; dr.COMPANY = Utils.Company; dr.UDATE = DateTime.Now; isnew = true; } else { Utils.Purinvid = drow.PURINVID; dr.EDATE = DateTime.Now; dr.EUSERID = Utils.Userid; } dr.SUPID = drow.SUPID; dr.SUPNAME = drow.SUPNAME; dr.INVDATE = drow.INVDATE; dr.INVNO = drow.INVNO; dr.DUEDAYS = drow.DUEDAYS; dr.SPDISCOUNT = drow.SPDISCOUNT; dr.WHID = drow.WHID; dr.ADJVALUE = drow.ADJVALUE; dr.NETVALUE = drow.NETVALUE; dr.HOLD = drow.HOLD; if (isnew) { dt.Rows.Add(dr); taPurMain.Update(dt); } else { dr.EndEdit(); taPurMain.Update(dr); } //bool issale = false;//string tostore = string.Empty; //STOCK if (!drow.HOLD) { if (issale) { new StockMaster().CreateStock(ref cn, ref tran, purinvdetail, drow.WHID, "S", true, false); } else { new StockMaster().CreateStock(ref cn, ref tran, purinvdetail, drow.WHID, "P", true, false); } //Price Master taPriceMaster.Update(new PriceMaster().UpdatePriceMaster(purinvdetail, drow.SUPID)); //UPDATE LASTPRICE,LASTEXPIRY,LASTCOSTPRICE //LEDGER taapar.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Purinvid, dr.INVNO, dr.NETVALUE, 0, dr.NETVALUE, Utils.Company, 1, Utils.Userid, 0); taledger.Insert("S", dr.SUPID, DateTime.Now.Date, dr.INVDATE, Utils.Purinvid, dr.INVNO, 0, dr.NETVALUE, 1, Utils.Company, Utils.Userid,"Purchase Invoice"); } foreach (DsPurchase.PURINVDETAILRow purd in purinvdetail.Rows) { if ((purd.RowState != DataRowState.Deleted)) { purd.PURINVID = Utils.Purinvid; if (!purd.IsISSUEFORSALENull()) { issale = purd.ISSUEFORSALE; tostore = purd.TOSTORE; } // Item Master Price if (!drow.HOLD) { taItemMaster.UpdateCPSP(purd.SPRICE, purd.CPRICE, purd.ITEMNO); } } } taPurDetail.Update(purinvdetail); tran.Commit(); dm.UpdateAutoNum(1); retval = "1"; } catch (Exception ex) { if (tran != null) tran.Rollback(); if (isnew) Utils.Purinvid = string.Empty; retval = ex.ToString(); } return retval; }
public string DoUpLoadItems(string purid,bool ispurchase) { string retval = "1"; var taItem = new DsMasterTableAdapters.ITEMMASTTableAdapter(); var ds = new DsMaster().ITEMMAST; taItem.Connection.ConnectionString = _constr; // taItem.FillByBarCode() DataTable dtitems = null; dtitems = ispurchase ? new PurInvDataManager().GetItemMasterInPurchase(purid) : new PurInvDataManager().GetITEMsInTransfer(purid); string itemnos = dtitems.Rows.Cast<DataRow>().Aggregate("", (current, dr) => current + (dr["ITEMNO"].ToString() + ",")); // taItem.FillByItemnos(ds, itemnos); bool isnew = false; foreach (DataRow dr in dtitems.Rows) { bool update = true; taItem.FillByITEMNO(ds, dr["ITEMNO"].ToString()); var dsup = ds.FindByITEMNO(dr["ITEMNO"].ToString()); if (dsup != null) { isnew = false; dsup.BeginEdit(); update = Equals(dr, dsup); } else { dsup = (DsMaster.ITEMMASTRow)ds.NewRow(); isnew = true; } if (!update) { foreach (DataColumn dc in dtitems.Columns) { if (!dc.ReadOnly) dsup[dc.ColumnName] = dr[dc.ColumnName]; } } if (isnew) { ds.Rows.Add(dr.ItemArray); var t = taItem.Update(ds); if (t == 0) retval += "item mast not created"; } else { dsup.EndEdit(); taItem.Update(dsup); } isnew = false; } return retval; }
public string GetDefaultSupplier(string itemno) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter { Connection = { ConnectionString = _constr } }; return ta.GetDefaultSupplier(itemno); }
public void UpdateSpriceByItemno(string itemno, decimal sprice, ref SqlConnection connection, ref SqlTransaction transaction) { //var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter(); //ta.Connection = connection; //ta.Transaction = transaction; var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter { Connection = connection, Transaction = transaction }; ta.UpdateSPrice(sprice, itemno); }
public decimal GetPurchaseDist(string itemno) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; return ta.GetPurDiscount(itemno) ?? 0; }
public string GetItemname(string itemno) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter { Connection = { ConnectionString = _constr } }; return ta.GetItemName(itemno); }
public bool UpdateItems(DataTable dt) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; return ta.Update((DsMaster.ITEMMASTDataTable) dt) > 0; }
public decimal GetDiscount(string itemno) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter(); ta.Connection.ConnectionString = _constr; return ta.GetDiscount(itemno) ?? 0; }
public decimal GetItemSalesPrice(string itemno) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; return ta.GetSalesPrice(itemno) ?? 0; }
public bool UpdateItemasBarcode(string itemno) { var d = FindItemByBarCode(itemno); if (d.Count == 0) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; ta.UpdateQBarCode(itemno, itemno); return true; } return false; }
public DsMaster.ITEMMASTDataTable GetItemMastList() { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().ITEMMAST; ta.Fill(ds); return ds; }
public DsMaster.ITEMMASTDataTable FindItemByBarCode(string barcode) { var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster().ITEMMAST; ta.FillByBarCode(ds, barcode); return ds; }
public string DoSave() { string retval; SqlTransaction tran = null; var isnew = false; try { var cn = new SqlConnection {ConnectionString = _constr}; cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var dt = new DsMaster().ITEMMAST; var ta = new DsMasterTableAdapters.ITEMMASTTableAdapter(); ta.Connection.ConnectionString = _constr; ta.Fill(dt); ta.AssignConnection(cn, tran); var dr = dt.FindByITEMNO(Itemno); if (dr != null) { dr.BeginEdit(); dr.editedby = Utils.Userid; dr.editeddate = DateTime.Now.Date; } else { dr = (DsMaster.ITEMMASTRow) dt.NewRow(); isnew = true; var autoid = new DataManager().GetAutoId(12); autoid++; Utils.Itemno = Utils.Company + autoid.ToString("D5"); dr.ITEMNO = Utils.Itemno; dr.CREATEDBY = Utils.Userid; dr.CDATE = DateTime.Now.Date; if (ItemmastRow.OWNBARCODE && string.IsNullOrEmpty(ItemmastRow.BARCODE)) dr.BARCODE = Utils.Itemno; else { dr.BARCODE = ItemmastRow.BARCODE; } } dr.ITEMTYPE = ItemmastRow.ITEMTYPE; dr.OWNBARCODE = ItemmastRow.OWNBARCODE; dr.ITEMNAME = ItemmastRow.ITEMNAME; dr.ARITEMNAME = ItemmastRow.ARITEMNAME; dr.BASEUOM = ItemmastRow.BASEUOM; dr.SUPPLIERNO = ItemmastRow.SUPPLIERNO; dr.MANFNAME = ItemmastRow.MANFNAME; dr.REORDER = ItemmastRow.REORDER; dr.UOM = ItemmastRow.UOM; dr.PRINTBARCODE = ItemmastRow.PRINTBARCODE; dr.EXPDATEREQ = ItemmastRow.EXPDATEREQ; dr.ACTIVE = ItemmastRow.ACTIVE; dr.CATEGORY = ItemmastRow.CATEGORY; dr.GROUPID = ItemmastRow.GROUPID; dr.GENERICID = ItemmastRow.GENERICID; dr.MARGIN = ItemmastRow.MARGIN; dr.MARKUP = ItemmastRow.MARKUP; dr.DISCOUNT = ItemmastRow.DISCOUNT; dr.FASTMOVING = ItemmastRow.FASTMOVING; dr.LOCATION = ItemmastRow.LOCATION; dr.TEMPRATURE = ItemmastRow.TEMPRATURE; dr.MINQTY = ItemmastRow.MINQTY; dr.MAXQTY = ItemmastRow.MAXQTY; dr.COMPANY = Utils.Company; dr.SEL = false; dr.DISCONSALE = ItemmastRow.DISCONSALE; dr.CPRICE = ItemmastRow.CPRICE; dr.SPRICE = ItemmastRow.SPRICE; dr.ITEMDEM = ItemmastRow.ITEMDEM; dr.COLOR=ItemmastRow.COLOR; dr.WEIGHT=ItemmastRow.WEIGHT; dr.POMINQTY =ItemmastRow.POMINQTY; dr.POMAXQTY =ItemmastRow.POMAXQTY; dr.DISCONSALE = ItemmastRow.DISCONSALE; dr.SALEDISCOUNTPER = ItemmastRow.SALEDISCOUNTPER; if (isnew) { dt.Rows.Add(dr); ta.Update(dt); } else { dr.EndEdit(); ta.Update(dt); } new DataManager().UpdateAutoNum(12); tran.Commit(); retval = "1"; } catch (Exception ex) { retval = ex.ToString(); if (tran != null) tran.Rollback(); } return retval; }