protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objStock = new Store.Stock.BusinessObject.Stock();
oblStock = new Store.Stock.BusinessLogic.Stock();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objStock.StockID = Convert.ToInt32(dgvStock.DataKeys[gvrow.RowIndex].Value.ToString());
objMessageInfo = oblStock.ManageStockMaster(objStock, cmdMode);
BindStock();
updateStockBdInfo.Update();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1);
}
finally
{
objStock = null;
objMessageInfo = null;
oblStock = null;
}
}
void ManageStock()
{
objStock = new Store.Stock.BusinessObject.Stock();
oblStock = new Store.Stock.BusinessLogic.Stock();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objStock.StockID = Convert.ToInt32(txtStockId.Text);
}
else
{
objStock.StockID = 0;
}
objStock.ItemID = Convert.ToInt32(ddlItemId.SelectedItem.Value);
objStock.StockQuantity = Convert.ToInt32(txtQuantity.Text);
objMessageInfo = oblStock.ManageStockMaster(objStock, cmdMode);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1);
}
finally
{
objStock = null;
// objMessageInfo = null;
oblStock = null;
}
}
public Store.Common.MessageInfo ManageStock(Store.Stock.BusinessObject.Stock objstock, CommandMode cmdMode)
{
string SQL = "";
ParameterList paramList = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManageStock";
paramList.Add(new SQLParameter("@StockID", objstock.StockID));
paramList.Add(new SQLParameter("@ItemID", objstock.ItemID));
paramList.Add(new SQLParameter("@StockQuantity", objstock.StockQuantity));
paramList.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
if (dr.Read())
{
objMessageInfo = new Store.Common.MessageInfo();
objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]);
objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]);
objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]);
objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]);
objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]);
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1);
}
return(objMessageInfo);
}
public Store.Common.MessageInfo ManageStockMaster(Store.Stock.BusinessObject.Stock objStock, CommandMode cmdMode)
{
try
{
return(odlStock.ManageStock(objStock, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1);
return(null);
}
}
public Store.Stock.BusinessObject.StockList GetAllStockList(int StockID, int Flag, string FlagValue)
{
Store.Stock.BusinessObject.Stock objstock = null;
Store.Stock.BusinessObject.StockList objstockList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_stock";
objstockList = new BusinessObject.StockList();
paramList.Add(new SQLParameter("@StockID", StockID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objstock = new BusinessObject.Stock();
if (dr.IsDBNull(dr.GetOrdinal("StockID")) == false)
{
objstock.StockID = dr.GetInt32(dr.GetOrdinal("StockID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false)
{
objstock.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objstock.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("StockQuantity")) == false)
{
objstock.StockQuantity = dr.GetInt32(dr.GetOrdinal("StockQuantity"));
}
objstockList.Add(objstock);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1);
}
return(objstockList);
}
