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 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;
}
