protected void grdJobs_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 2;
obj.ID = Convert.ToInt32(grdJobs.DataKeys[e.RowIndex].Value);
obj.Jobs(obj);
LoadJobs(Convert.ToInt32(hdPID.Value));
}
public void GetJobsByProject(int ProjectID)
{
clsProjectJob obj = new clsProjectJob();
obj.ProjectID = ProjectID;
obj.Op = 3;
DataTable dt = obj.Jobs(obj).Tables[0];
Context.Response.Write(JsonConvert.SerializeObject(dt));
}
protected void grdProject_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 2;
obj.ID = Convert.ToInt32(grdProject.DataKeys[e.RowIndex].Value);
obj.Projects(obj);
LoadProjects();
pnlJobs.Visible = false;
}
protected void btnSaveJob_Click(object sender, EventArgs e)
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 1;
obj.ProjectID = Convert.ToInt32(hdPID.Value);
obj.JobName = txtJobName.Text;
obj.Jobs(obj);
LoadJobs(Convert.ToInt32(hdPID.Value));
txtJobName.Text = "";
}
protected void btnSaveProject_Click(object sender, EventArgs e)
{
clsProjectJob obj = new clsProjectJob();
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
obj.Op = 1;
obj.ProjectDate = txtProjectDate.Text;
obj.ProjectName = txtProjectName.Text;
obj.Projects(obj);
LoadProjects();
txtProjectDate.Text = "";
txtProjectName.Text = "";
}
protected void grdJobs_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 4;
obj.ID = Convert.ToInt32(grdJobs.DataKeys[e.RowIndex].Value);
TextBox txtEJobName = (TextBox)grdJobs.Rows[e.RowIndex].FindControl("txtEJobName");
obj.JobName = txtEJobName.Text;
obj.Jobs(obj);
grdJobs.EditIndex = -1;
LoadJobs(Convert.ToInt32(hdPID.Value));
}
void LoadProjects()
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 3;
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.Projects(obj).Tables[0];
ddlProject.DataSource = dt;
ddlProject.DataTextField = "ProjectName";
ddlProject.DataValueField = "ID";
ddlProject.DataBind();
}
void LoadJobs(int ProjectID)
{
try
{
clsProjectJob obj = new clsProjectJob();
obj.ProjectID = ProjectID;
obj.Op = 3;
DataTable dt = obj.Jobs(obj).Tables[0];
ddlJob.DataSource = dt;
ddlJob.DataValueField = "ID";
ddlJob.DataTextField = "JobName";
ddlJob.DataBind();
}
catch
{
}
}
void LoadProjects()
{
try
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 3;
obj.SiteID = Convert.ToInt32(ddlSiteCustomer.SelectedValue);
DataTable dt = obj.Projects(obj).Tables[0];
ddlProject.DataSource = dt;
ddlProject.DataValueField = "ID";
ddlProject.DataTextField = "ProjectName";
ddlProject.DataBind();
}
catch
{
}
}
void LoadJobs()
{
try
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 3;
obj.ProjectID = Convert.ToInt32(ddlProject.SelectedValue);
DataTable dt = obj.Jobs(obj).Tables[0];
ddlJob.DataSource = dt;
ddlJob.DataValueField = "ID";
ddlJob.DataTextField = "JobName";
ddlJob.DataBind();
CreateReferenceNo();
}
catch
{
}
}
void LoadJobs(int ProjectID)
{
clsProjectJob obj = new clsProjectJob();
obj.ProjectID = ProjectID;
obj.Op = 3;
DataTable dt = obj.Jobs(obj).Tables[0];
grdJobs.DataSource = dt;
grdJobs.DataBind();
if (grdJobs.Rows.Count > 0)
{
lblErrorJob.Text = "";
}
else
{
lblErrorJob.Text = "No Records found";
}
}
void LoadProjects()
{
clsProjectJob obj = new clsProjectJob();
obj.Op = 3;
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.Projects(obj).Tables[0];
grdProject.DataSource = dt;
grdProject.DataBind();
if (grdProject.Rows.Count > 0)
{
lblErrorProject.Text = "";
}
else
{
lblErrorProject.Text = "No Records found";
}
}
/*
* Op=1 Insert Data
* Op=2 Delete Data
* Op=3 Get All Data
*/
//ID, ProjectID, JobName
public DataSet Jobs(clsProjectJob obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@ProjectID", obj._ProjectID);
param[2] = new SqlParameter("@JobName", obj._JobName);
param[3] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procJobs", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
