public bool AddItemsAdjustment(ItemStockAdjustment itemAdj)
{
bool success = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Items_Adjustment_InsItems);
db.AddInParameter(dbCommand, "@iItemId", DbType.Int32, itemAdj.ItemId);
db.AddInParameter(dbCommand, "@sDescription", DbType.String, itemAdj.Description);
db.AddInParameter(dbCommand, "@iQty", DbType.Int32, itemAdj.Qty);
db.AddInParameter(dbCommand, "@iCreatedBy", DbType.Int32, itemAdj.UserId);
db.AddOutParameter(dbCommand, "@iId", DbType.Int32, 4);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int newID = (int)db.GetParameterValue(dbCommand, "@iId");
if (newID > 0)
{
success = true;
itemAdj.Id = newID;
}
}
if (success)
{
Item item = new Item();
item.ItemId = itemAdj.ItemId;
this.GetItemsByID(item);
ItemHistory itemHistory = new ItemHistory(item);
itemHistory.HistoryTypeId = Structures.ItemHistoryTypes.StockAdjustment;
itemHistory.UserId = itemAdj.UserId;
itemHistory.Qty = itemAdj.Qty;
itemHistory.RefNo = itemAdj.Id.ToString();
AddItemsHistory(itemHistory, null);
}
}
catch (System.Exception ex)
{
ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddItemsAdjustment(ItemStockAdjustment itemAdj)");
throw ex;
}
return success;
}
///
/// Item stock adjustment methods
///
#region Add Adjustment
public bool AddItemsAdjustment(ItemStockAdjustment itemAdj)
{
bool success = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Items_Adjustment_InsItems);
db.AddInParameter(dbCommand, "@iItemId", DbType.Int32, itemAdj.ItemId);
db.AddInParameter(dbCommand, "@sDescription", DbType.String, itemAdj.Description);
db.AddInParameter(dbCommand, "@iQty", DbType.Int32, itemAdj.Qty);
db.AddInParameter(dbCommand, "@iCreatedBy", DbType.Int32, itemAdj.UserId);
db.AddOutParameter(dbCommand, "@iId", DbType.Int32, 4);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int newID = (int)db.GetParameterValue(dbCommand, "@iId");
if (newID > 0)
{
success = true;
itemAdj.Id = newID;
}
}
if (success)
{
Item item = new Item();
item.ItemId = itemAdj.ItemId;
this.GetItemsByID(item);
ItemHistory itemHistory = new ItemHistory(item);
itemHistory.HistoryTypeId = Structures.ItemHistoryTypes.StockAdjustment;
itemHistory.UserId = itemAdj.UserId;
itemHistory.Qty = itemAdj.Qty;
itemHistory.RefNo = itemAdj.Id.ToString();
AddItemsHistory(itemHistory, null);
}
}
catch (System.Exception ex)
{
ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddItemsAdjustment(ItemStockAdjustment itemAdj)");
throw ex;
}
return(success);
}
protected void btnSaveAdj_Click(object sender, EventArgs e)
{
try
{
if (seQuantity.Text == "0")
{
lblError.Visible = true;
lblError.Text = "Invalid Quantity";
return;
}
else
{
lblError.Visible = false;
lblError.Text = "";
}
ItemStockAdjustment stock = new ItemStockAdjustment();
stock.Description = txtDescription.Text.Trim();
stock.Qty = Int32.Parse(seQuantity.Text);
stock.ItemId = ObjItem.ItemId;
stock.UserId = Master.LoggedUser.UserId;
if (new ItemsDAO().AddItemsAdjustment(stock))
{
txtDescription.Text = string.Empty;
seQuantity.Text = "0";
LoadAlterations();
}
}
catch (Exception ex)
{
ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSaveAdj_Click(object sender, EventArgs e)");
if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty)
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false);
else
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false);
}
}
