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