public string DoSave() { var dm = new ItemMaster {ItemmastRow = Itemmast,Itemno = Itemno}; var retval = dm.DoSave(); if (retval == "1") { Itemno = Utils.Itemno; } return retval; }
public string DoUploadPromotionItems(Ledgers.PROMOITEMSDataTable dtp,bool isRemote) { string retval; SqlTransaction tran = null; try { //isRemote true mean data downloading in local machine , isremote false mean data uploading in sync if (isRemote) _syncConstr = Utils.Connectionstring; var cn = new SqlConnection(_syncConstr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ds = new Ledgers(); //var dt = ds.COMMISIONMAST; var dtdetail = ds.PROMOITEMS; var taCommMain = new PROMOITEMSTableAdapter(); taCommMain.AssignConnection(cn, tran); var clstock = new StockMaster(); var clitem = new ItemMaster(); foreach (Ledgers.PROMOITEMSRow ditemdetarow in dtp.Rows) { var newdetrow = dtdetail.NewRow(); //dtdetail.TIDColumn.AutoIncrement = false; //dtdetail.TIDColumn.ReadOnly = false; if (isRemote) { clstock.UpdateSpriceByItemno(ditemdetarow.ITEMNO, ditemdetarow.NEWPRICE, ref cn, ref tran); clitem.UpdateSpriceByItemno(ditemdetarow.ITEMNO, ditemdetarow.NEWPRICE, ref cn, ref tran); } foreach (DataColumn dc in dtp.Columns) { //if (!dc.ReadOnly) //{ newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName]; // } } dtdetail.Rows.Add(newdetrow); } taCommMain.Update(dtdetail); tran.Commit(); retval = "1"; } catch (Exception ex) { if (tran != null) tran.Rollback(); retval = ex.ToString(); } return retval; }
public void ResetThePromotionPrice(DateTime dt1) { string retval = "0"; SqlTransaction tran = null; var cn = new SqlConnection(_constr); try { cn.Open(); var t = new Ledgers.PROMOITEMSDataTable(); var tam = new LedgersTableAdapters.PROMOITEMSTableAdapter().FillByToDate(t, dt1); PromoitemsDataTable = t; tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); // tam.AssignConnection(cn, tran); var clstock = new StockMaster(); var clitem = new ItemMaster(); foreach (Ledgers.PROMOITEMSRow dr in PromoitemsDataTable.Rows) { //dr.POSTED = true; clstock.UpdateSpriceByItemno(dr.ITEMNO, dr.OLDPRICE, ref cn, ref tran); clitem.UpdateSpriceByItemno(dr.ITEMNO, dr.OLDPRICE, ref cn, ref tran); } tran.Commit(); // retval = "1"; } catch (Exception ex) { retval = ex.ToString(); if (tran != null && cn.State == ConnectionState.Open) { tran.Rollback(); } } }
public void AddNewItemItemInStock(ref SqlConnection cn, ref SqlTransaction tran, DataRow d,DsInventory.STOCKMASTERDataTable dsm) { string wh = Utils.SalesStoreCode; const string storetype = "S"; // var ds = new DsInventory().STOCKMASTER; var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = _constr } }; var taup = new DsInventoryTableAdapters.STOCKMASTERTableAdapter {Connection = cn, Transaction = tran}; // ta.FillByItemNoAll(ds, d["ITEMNO"].ToString(), Utils.Company); DataRow[] ds = dsm.Select( "ITEMNO='" + d["ITEMNO"].ToString() + "'"); int qty = int.Parse(d["qty"].ToString()) * -1; // if (ds.Rows.Count > 0) //{ foreach (DsInventory.STOCKMASTERRow dr in ds) { if (dr.SPRICE == decimal.Parse(d["INVRATE"].ToString())) { taup.UpdateSaleQtyByStockid(qty, dr.STOCKID); taup.UpdateQtyByStockID(qty, dr.STOCKID); return; } } //} var cprice = new ItemMaster().GetItemCostPrice(d["itemno"].ToString()); var sprice = decimal.Parse(d["INVRATE"].ToString()); var sdisc = new ItemMaster().GetPurchaseDist(d["itemno"].ToString()); if (cprice == 0) { sprice = decimal.Parse(d["INVRATE"].ToString()); cprice = sprice - sprice * sdisc / 100; } if(!string.IsNullOrEmpty(d["EXPDATE"].ToString())) taup.Insert(d["ITEMNO"].ToString(), d["BARCODE"].ToString(), qty, sprice, cprice, DateTime.Parse(d["EXPDATE"].ToString()), storetype, null, null, null, false, wh, Utils.Company, qty, null); else taup.Insert(d["ITEMNO"].ToString(), d["BARCODE"].ToString(), qty, sprice, cprice, null, storetype, null, null, null, false, wh, Utils.Company, qty, null); }
public string DoSave(bool isdownload=false) { string retval = "0"; SqlTransaction tran = null; var cn = new SqlConnection(_constr); try { cn.Open(); var tam = new LedgersTableAdapters.PROMOITEMSTableAdapter(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); tam.AssignConnection(cn, tran); var clstock = new StockMaster(); var clitem = new ItemMaster(); foreach (Ledgers.PROMOITEMSRow dr in PromoitemsDataTable.Rows) { if (!isdownload) { if (!dr.POSTED) { dr.POSTED = true; clstock.UpdateSpriceByItemno(dr.ITEMNO, dr.NEWPRICE, ref cn, ref tran); clitem.UpdateSpriceByItemno(dr.ITEMNO, dr.NEWPRICE, ref cn, ref tran); } } else { dr.POSTED = true; clstock.UpdateSpriceByItemno(dr.ITEMNO, dr.NEWPRICE, ref cn, ref tran); clitem.UpdateSpriceByItemno(dr.ITEMNO, dr.NEWPRICE, ref cn, ref tran); } } tam.Update(PromoitemsDataTable); tran.Commit(); retval = "1"; } catch (Exception ex) { retval = ex.ToString(); if (tran != null && cn.State == ConnectionState.Open) { tran.Rollback(); } } return retval; }
public DsMaster.TEMPBCODEPRINTDataTable CreateBarcodeList(string purinvno) { var d = new Purchasing.PurInvDataManager().GetPurInvDetailsById(purinvno); var im = new ItemMaster(); var dt = new DsMaster.TEMPBCODEPRINTDataTable(); foreach (DataRow dr in d.Rows) { var ndr = dt.NewRow(); ndr[1] = dr["itemno"]; ndr[1] = im.GetItemname(dr["itemno"].ToString()); ndr[2] = int.Parse(dr["Qty"].ToString()) + int.Parse((string.IsNullOrEmpty(dr["BONUSQTY"].ToString()) ? "0": dr["BONUSQTY"]).ToString()); ndr[4] = 0; dt.Rows.Add(ndr); } return dt; }
private void textBox1_KeyDown(object sender, KeyEventArgs e) { if(e.KeyCode==Keys.Enter) { // if (!itemfoundingrid()) // { var blf = new BlItemMaster().FindItemByBarCode(textBox1.Text); if (blf.Rows.Count == 0) { XtraMessageBox.Show("Item not found", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information); textBox1.Clear(); } else { var dr = blf.Rows[0]; var drs = new ItemMaster().GetSPCPEXPDtFromImportedPurchaseFile(dr["itemno"].ToString(), dr["barcode"].ToString()); sPCPRICEFROMHISTBindingSource.DataSource = drs; if(drs.Rows.Count >0) lookUpEdit1.EditValue =drs.Rows[0]["sprice"]; txtstock.EditValue = 0; textBox1.Text = dr["itemno"].ToString(); txtbarcode.Text = dr["barcode"].ToString(); // txtsprice.EditValue = new ItemMaster().GetItemSalesPrice(dr["itemno"].ToString()); //txtcprice.EditValue = new ItemMaster().GetItemCostPrice(dr["itemno"].ToString()); txxitemname.Text = dr["itemname"].ToString(); //textBox1.Tag = drs["ITCD"] txtgrpid.Text = dr["GROUPID"].ToString(); string dt = new BLSales().GetExpiryDt(dr["ITEMNO"].ToString()); if(!String.IsNullOrEmpty(dt)) { DateTime ndt = DateTime.Parse(dt); txtexpdate.Text = ndt.Month + " - " + ndt.Year; } button1.Enabled = true; txtstock.Focus(); // } } //else //{ // button1.Enabled = false; //} } if (e.KeyCode == Keys.F10) { KeyF10(); } }
private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { progressPanel1.Visible = true; Application.DoEvents(); foreach (DsInventory.YearEndInventoryRow dr in _dsyearend) { decimal sprice = 0; decimal cprice = 0; if (!string.IsNullOrEmpty(dr["Sprice"].ToString())) sprice = decimal.Parse(dr["Sprice"].ToString()); if (!string.IsNullOrEmpty(dr["Cprice"].ToString())) cprice = decimal.Parse(dr["Cprice"].ToString()); if (sprice == 0) { dr["Sprice"] = new ItemMaster().GetSCpriceFromImportedPurchaseFile(false, dr["itemno"].ToString(), dr["barcode"].ToString()); } // dr["cprice"] = Decimal.Round(new ItemMaster().GetSCpriceFromImportedPurchaseFile(true, dr["itemno"].ToString(), dr["barcode"].ToString()), 2); if (cprice == 0) { cprice = Decimal.Round(new ItemMaster().GetSCpriceFromImportedPurchaseFile(true, dr["itemno"].ToString(), dr["barcode"].ToString()), 2); if(cprice==0) { var disc = new ItemMaster().GetPurchaseDist(dr["itemno"].ToString()); //if(dr["itemno"].ToString()=="5613603") //{ // disc = new ItemMaster().GetPurchaseDist(dr["itemno"].ToString()); //} cprice = sprice - sprice * ( disc / 100); } dr["cprice"] = cprice; //Decimal.Round(new ItemMaster().GetSCpriceFromImportedPurchaseFile(true, dr["itemno"].ToString(),dr["barcode"].ToString()), 2); } barButtonItem4.Enabled = true; } progressPanel1.Visible = false; }
void AppendDataToGrid(string itemno,string barcode,string itemname, int grpid, int qty,string expdate,string machno,string inventoryby,int Yearclosed, bool nostock=false) { try{ var stk = new StockMaster().GetAvgMaxQtySpCpExpDtFromStock(itemno,Yearclosed); var dr = _dsyearend.NewRow(); dr["ITEMNO"] = itemno; dr["BARCODE"] = barcode; dr["ITEMNAME"] = itemname; decimal cprice = 0; decimal sprice = 0; if (stk.Tables[0].Rows.Count > 0) { foreach (DataRow dss in stk.Tables[0].Rows) { dr["INSTOCK"] = 0; if (!string.IsNullOrEmpty(dss["QTY"].ToString())) dr["INSTOCK"] = dss["QTY"]; dr["EXPDATE"] = dss["Expdate"]; if (!string.IsNullOrEmpty(dss["Sprice"].ToString())) dr["SPRICE"] = decimal.Parse(dss["Sprice"].ToString()); if (!string.IsNullOrEmpty(dss["Cprice"].ToString())) dr["CPRICE"] = decimal.Parse(dss["Cprice"].ToString()); } } else { dr["INSTOCK"] = 0; dr["SPRICE"] = new ItemMaster().GetItemSalesPrice(itemno); dr["CPRICE"] = new ItemMaster().GetItemCostPrice(itemno); if(sprice > 0 && cprice==0) { var disc = new ItemMaster().GetPurchaseDist(itemno); cprice = sprice - ((sprice*disc)/100); } dr["CPRICE"] = cprice; } dr["PHYSICALSTOCK"] = qty; dr["CDATE"] = DateTime.Now; dr["NOMASTER"] = nostock; dr["MACHINENO"] = machno; dr["MUSER"] = inventoryby; dr["GROUPID"] = grpid; dr["COMP"] = Utils.Company; dr["TRANSFERED"] = 0; dr["INVENTORYYEAR"] = Yearclosed; _dsyearend.Rows.Add(dr); } catch(Exception ex) { } }