protected void btnDelete_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
TblAssestStock stock = new TblAssestStock(btn.CommandArgument);
TblAssestStore store = new SubSonic.Select()
.From(TblAssestStore.Schema)
.Where(TblAssestStore.Columns.ItemID).IsEqualTo(stock.ItemID)
.And(TblAssestStore.Columns.BranchID).IsEqualTo(Session["BranchID"])
.ExecuteSingle <TblAssestStore>();
store.Quantity -= stock.Quantity;
store.Save();
TblAssestStock.Delete(btn.CommandArgument);
LoadStock();
string msg = "Item has been deleted!";
lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check");
}
private void UpdateStore()
{
TblAssestStore store;
if (hdnid.Value == "")
{
Query qry = new Query(TblAssestStore.Schema);
qry.AddWhere(TblAssestStore.Columns.ItemID, Comparison.Equals, ddlItems.SelectedValue).AND
(TblAssestStore.Columns.BranchID, Comparison.Equals, Session["BranchID"]);
DataTable dt = qry.ExecuteDataSet().Tables[0];
if (dt.Rows.Count == 0)
{
}
else
{
store = new SubSonic.Select()
.From(TblAssestStore.Schema)
.Where(TblAssestStore.Columns.ItemID).IsEqualTo(ddlItems.SelectedValue)
.And(TblAssestStore.Columns.BranchID).IsEqualTo(Session["BranchID"])
.ExecuteSingle <TblAssestStore>();
store.IsNew = false;
store.Quantity -= Convert.ToInt32(txtQuantity.Text);
store.Save();
}
}
else
{
store = new SubSonic.Select()
.From(TblAssestStore.Schema)
.Where(TblAssestStore.Columns.ItemID).IsEqualTo(ddlItems.SelectedValue)
.And(TblAssestStore.Columns.BranchID).IsEqualTo(Session["BranchID"])
.ExecuteSingle <TblAssestStore>();
store.IsNew = false;
if (Convert.ToInt32(txtQuantity.Text) > Convert.ToInt32(hdnQuantity.Value))
{
store.Quantity -= Convert.ToInt32(txtQuantity.Text) - Convert.ToInt32(hdnQuantity.Value);
}
else
{
store.Quantity += Convert.ToInt32(hdnQuantity.Value) - Convert.ToInt32(txtQuantity.Text);
}
store.Save();
}
}
