/*
* Op=1 Insert Data
* Op=2 Update Status
* Op=3 Get All Requests
* Op=4 Get All Data By Site
* Op=5 Get All Data By UserID
*/
//ID, SiteID, UserID, PartNo, Description, Photo, Status
public DataSet SitePartRequest(clsSitePartRequest obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@SiteID", obj._SiteID);
param[2] = new SqlParameter("@UserID", obj._UserID);
param[3] = new SqlParameter("@EntryDate", obj._EntryDate);
param[4] = new SqlParameter("@PartNo", obj._PartNo);
param[5] = new SqlParameter("@Description", obj._Description);
param[6] = new SqlParameter("@Photo", obj._Photo);
param[7] = new SqlParameter("@Status", obj._Status);
param[8] = new SqlParameter("@FromSite", obj._FromSite);
param[9] = new SqlParameter("@ItemType", obj._ItemType);
param[10] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procSitePartRequest", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
protected void grdParts_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsSitePartRequest obj = new clsSitePartRequest();
obj.ID = Convert.ToInt32(grdParts.DataKeys[e.RowIndex].Value);
obj.Op = 6;
obj.SitePartRequest(obj);
LoadData();
}
protected void grdPartRequest_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsSitePartRequest obj = new clsSitePartRequest();
obj.Op = 7;
obj.ID = Convert.ToInt32(grdPartRequest.DataKeys[e.RowIndex].Value);
obj.FromSite = Convert.ToInt32(Request.Cookies["SiteID"].Value);
obj.SitePartRequest(obj);
LoadData();
}
protected void grdParts_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList ddlEStatus = (DropDownList)grdParts.Rows[e.RowIndex].FindControl("ddlEStatus");
TextBox txtEPartNo = (TextBox)grdParts.Rows[e.RowIndex].FindControl("txtEPartNo");
clsSitePartRequest obj = new clsSitePartRequest();
obj.Op = 2;
obj.ID = Convert.ToInt32(grdParts.DataKeys[e.RowIndex].Value);
obj.PartNo = txtEPartNo.Text;
obj.Status = Convert.ToInt32(ddlEStatus.SelectedValue);
obj.SitePartRequest(obj);
grdParts.EditIndex = -1;
LoadData();
}
protected void btnSave_Click(object sender, EventArgs e)
{
clsSitePartRequest obj = new clsSitePartRequest();
//ID, SiteID, UserID, PartNo, Description, Photo, Status
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
obj.UserID = Convert.ToInt32(Request.Cookies["User"].Value);
obj.EntryDate = DateTime.Today.ToShortDateString();
obj.PartNo = txtPartNo.Text;
obj.Description = txtDescription.Text;
obj.Status = 0;
obj.Photo = UploadPhoto();
obj.FromSite = Convert.ToInt32(ddlSite.SelectedValue);
obj.ItemType = Convert.ToInt32(rdItemType.SelectedValue);
obj.Op = 1;
obj.SitePartRequest(obj);
LoadData();
pnlExisting.Visible = true;
txtPartNo.Text = "";
txtDescription.Text = "";
}
void LoadData()
{
clsSitePartRequest obj = new clsSitePartRequest();
obj.Op = 3;
DataTable dt = obj.SitePartRequest(obj).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Photo"] = "~/" + dt.Rows[i]["Photo"];
}
grdPartRequest.DataSource = dt;
grdPartRequest.DataBind();
if (grdPartRequest.Rows.Count == 0)
{
lblError.Text = "No Records found";
}
else
{
lblError.Text = "";
}
}
void LoadData()
{
clsSitePartRequest obj = new clsSitePartRequest();
obj.Op = 8;
obj.FromSite = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.SitePartRequest(obj).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Photo"] = "~/" + dt.Rows[i]["Photo"];
}
grdPartRequest.DataSource = dt;
grdPartRequest.DataBind();
if (grdPartRequest.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No Records found";
}
}
void LoadData()
{
clsSitePartRequest obj = new clsSitePartRequest();
if (ddlSites.SelectedIndex == ddlSites.Items.Count - 1)
{
obj.Op = 3;
}
else
{
obj.SiteID = Convert.ToInt32(ddlSites.SelectedValue);
obj.Op = 4;
}
DataTable dt = obj.SitePartRequest(obj).Tables[0];
foreach (DataRow dr in dt.Rows)
{
if (dr["Photo"] != "")
{
dr["Photo"] = "~/" + dr["Photo"];
}
else
{
dr["Photo"] = "No Image";
}
}
grdParts.DataSource = dt;
grdParts.DataBind();
if (grdParts.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No Records Found";
}
}
