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