void LoadAllData() { try { clsWorkshopItemTransaction obj = new clsWorkshopItemTransaction(); obj.Op = 5; DataTable dt = obj.WorkshopItemTransaction(obj).Tables[0]; grdItems.DataSource = dt; grdItems.DataBind(); int Qty = 0; foreach (DataRow dr in dt.Rows) { Qty = Qty + Convert.ToInt32(dr["Quantity"]); } grdItems.FooterRow.Cells[4].Text = Qty.ToString(); if (grdItems.Rows.Count > 0) { lblError.Text = ""; } else { lblError.Text = "No Records found"; } } catch { } }
protected void grdItems_RowDeleting(object sender, GridViewDeleteEventArgs e) { clsWorkshopItemTransaction obj = new clsWorkshopItemTransaction(); obj.Op = 2; obj.ID = Convert.ToInt32(grdItems.DataKeys[e.RowIndex].Value); obj.WorkshopItemTransaction(obj); LoadData(); }
protected void grdItems_RowUpdating(object sender, GridViewUpdateEventArgs e) { clsWorkshopItemTransaction obj = new clsWorkshopItemTransaction(); obj.Op = 3; obj.ID = Convert.ToInt32(grdItems.DataKeys[e.RowIndex].Value); TextBox txtEQuantity = (TextBox)grdItems.Rows[e.RowIndex].FindControl("txtEQuantity"); obj.Quantity = Convert.ToInt32(txtEQuantity.Text); obj.WorkshopItemTransaction(obj); grdItems.EditIndex = -1; LoadData(); }
protected void btnAdd_Click(object sender, EventArgs e) { clsWorkshopItemTransaction obj = new clsWorkshopItemTransaction(); obj.ItemID = Convert.ToInt32(hdItemID.Value); obj.Op = 1; if (ddlTransactionType.SelectedValue == "1") { obj.Quantity = Convert.ToInt32(txtQuantity.Text); } else { obj.Quantity = -Convert.ToInt32(txtQuantity.Text); } obj.Status = Convert.ToInt32(ddlTransactionType.SelectedValue); obj.WorkshopItemTransaction(obj); LoadData(); }
void LoadData() { try { clsWorkshopItemTransaction obj = new clsWorkshopItemTransaction(); obj.Op = 4; obj.ItemID = Convert.ToInt32(hdItemID.Value); DataTable dt = obj.WorkshopItemTransaction(obj).Tables[0]; grdItems.DataSource = dt; grdItems.DataBind(); int Qty = 0; foreach (DataRow dr in dt.Rows) { Qty = Qty + Convert.ToInt32(dr["Quantity"]); } grdItems.FooterRow.Cells[4].Text = Qty.ToString(); } catch { LoadAllData(); } }
/* * Op=1 Insert Data * Op=2 Delete Data * Op=3 Update Data * Op=4 Get Transactions by Item */ //ID, ItemID, EntryDate, Quantity, Status public DataSet WorkshopItemTransaction(clsWorkshopItemTransaction obj) { try { connect(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID", obj._ID); param[1] = new SqlParameter("@ItemID", obj._ItemID); param[2] = new SqlParameter("@EntryDate", obj._EntryDate); param[3] = new SqlParameter("@Quantity", obj._Quantity); param[4] = new SqlParameter("@Status", obj._Status); param[5] = new SqlParameter("@Op", obj._Op); DataSet ds = SqlHelper.ExecuteDataset(co, "procWorkshopItemTransaction", param); return(ds); } catch { return(null); } finally { co.Close(); } }