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)
{
}
}
