void LoadData()
{
clsWorkshopItemMaster obj = new clsWorkshopItemMaster();
obj.Op = 4;
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.WorkshopItemMaster(obj).Tables[0];
grdItems.DataSource = dt;
grdItems.DataBind();
if (dt.Rows.Count == 0)
{
dt.Rows.Add();
}
grdItems.DataSource = dt;
grdItems.DataBind();
if (dt.Rows[0][0].ToString() == "")
{
grdItems.Rows[0].Controls.Clear();
TableCell cell = new TableCell();
cell.Text = "No Data Found";
grdItems.Rows[0].Cells.Add(cell);
}
if (grdItems.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No Records found";
}
}
protected void grdItems_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsWorkshopItemMaster obj = new clsWorkshopItemMaster();
obj.ID = Convert.ToInt32(grdItems.DataKeys[e.RowIndex].Value);
obj.Op = 3;
obj.WorkshopItemMaster(obj);
LoadData();
}
protected void txtItemName_TextChanged(object sender, EventArgs e)
{
clsWorkshopItemMaster obj = new clsWorkshopItemMaster();
obj.ItemName = txtItemName.Text;
obj.Op = 5;
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.WorkshopItemMaster(obj).Tables[0];
grdItemList.DataSource = dt;
grdItemList.DataBind();
grdItemList.Visible = true;
}
protected void grdItems_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
clsWorkshopItemMaster obj = new clsWorkshopItemMaster();
obj.ID = Convert.ToInt32(grdItems.DataKeys[e.RowIndex].Value);
obj.Op = 2;
TextBox txtEItemName = (TextBox)grdItems.Rows[e.RowIndex].FindControl("txtEItemName");
TextBox txtEDescription = (TextBox)grdItems.Rows[e.RowIndex].FindControl("txtEDescription");
obj.ItemName = txtEItemName.Text;
obj.Description = txtEDescription.Text;
obj.WorkshopItemMaster(obj);
grdItems.EditIndex = -1;
LoadData();
}
protected void grdItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Add")
{
clsWorkshopItemMaster obj = new clsWorkshopItemMaster();
obj.Op = 1;
TextBox txtItemName = (TextBox)grdItems.FooterRow.FindControl("txtItemName");
TextBox txtDescription = (TextBox)grdItems.FooterRow.FindControl("txtDescription");
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
obj.ItemName = txtItemName.Text;
obj.Description = txtDescription.Text;
obj.WorkshopItemMaster(obj);
LoadData();
}
}
/*
* Op=1 Insert Data
* Op=2 Update Data
* Op=3 Delete Data
* Op=4 Get All Data
* Op=5 Search Data
*/
//@ID, @SiteID, @ItemName, @Description, @Op
public DataSet WorkshopItemMaster(clsWorkshopItemMaster obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@SiteID", obj._SiteID);
param[2] = new SqlParameter("@ItemName", obj._ItemName);
param[3] = new SqlParameter("@Description", obj._Description);
param[4] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procWorkshopItemMaster", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
