public static HR_JobPosting GetHR_JobPostingByJobPostingID(int JobPostingID)
{
HR_JobPosting hR_JobPosting = new HR_JobPosting();
SqlHR_JobPostingProvider sqlHR_JobPostingProvider = new SqlHR_JobPostingProvider();
hR_JobPosting = sqlHR_JobPostingProvider.GetHR_JobPostingByJobPostingID(JobPostingID);
return hR_JobPosting;
}
public static HR_JobPosting GetHR_SupervisorBySupervisorID(string SupervisorID)
{
HR_JobPosting hR_JobPosting = new HR_JobPosting();
SqlHR_JobPostingProvider sqlHR_JobPostingProvider = new SqlHR_JobPostingProvider();
hR_JobPosting = sqlHR_JobPostingProvider.GetHR_JobPostingBySupervisorID(SupervisorID);
return hR_JobPosting;
}
public static HR_JobPosting GetHR_DesignationByDesignationID(int DesignationID)
{
HR_JobPosting hR_JobPosting = new HR_JobPosting();
SqlHR_JobPostingProvider sqlHR_JobPostingProvider = new SqlHR_JobPostingProvider();
hR_JobPosting = sqlHR_JobPostingProvider.GetHR_JobPostingByDesignationID(DesignationID);
return hR_JobPosting;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HR_JobPosting hR_JobPosting = new HR_JobPosting ();
hR_JobPosting.JobPostingID= int.Parse(Request.QueryString["ID"].ToString());
hR_JobPosting.EmployeeID = Profile.card_id;
hR_JobPosting.DepartmentID= int.Parse(ddlDepartmentID.SelectedValue);
hR_JobPosting.DesignationID= int.Parse(ddlDesignationID.SelectedValue);
hR_JobPosting.JoinDate= DateTime.Parse(txtJoinDate.Text);
hR_JobPosting.EndDate= DateTime.Parse(txtEndDate.Text);
hR_JobPosting.PostingStatus= txtPostingStatus.Text;
hR_JobPosting.JobLocation= txtJobLocation.Text;
hR_JobPosting.SupervisorID= ddlSupervisorID.SelectedValue;
hR_JobPosting.AddedBy= Profile.card_id;
hR_JobPosting.AddedDate= DateTime.Now;
hR_JobPosting.ModifiedBy= Profile.card_id;
hR_JobPosting.ModifiedDate= DateTime.Now;
bool resutl =HR_JobPostingManager.UpdateHR_JobPosting(hR_JobPosting);
Response.Redirect("AdminDisplayHR_JobPosting.aspx");
}
public static bool UpdateHR_JobPosting(HR_JobPosting hR_JobPosting)
{
SqlHR_JobPostingProvider sqlHR_JobPostingProvider = new SqlHR_JobPostingProvider();
return sqlHR_JobPostingProvider.UpdateHR_JobPosting(hR_JobPosting);
}
public static int InsertHR_JobPosting(HR_JobPosting hR_JobPosting)
{
SqlHR_JobPostingProvider sqlHR_JobPostingProvider = new SqlHR_JobPostingProvider();
return sqlHR_JobPostingProvider.InsertHR_JobPosting(hR_JobPosting);
}
public bool UpdateHR_JobPosting(HR_JobPosting hR_JobPosting)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_JobPosting", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@JobPostingID", SqlDbType.Int).Value = hR_JobPosting.JobPostingID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_JobPosting.EmployeeID;
cmd.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = hR_JobPosting.DepartmentID;
cmd.Parameters.Add("@DesignationID", SqlDbType.Int).Value = hR_JobPosting.DesignationID;
cmd.Parameters.Add("@JoinDate", SqlDbType.DateTime).Value = hR_JobPosting.JoinDate;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = hR_JobPosting.EndDate;
cmd.Parameters.Add("@PostingStatus", SqlDbType.NVarChar).Value = hR_JobPosting.PostingStatus;
cmd.Parameters.Add("@JobLocation", SqlDbType.NVarChar).Value = hR_JobPosting.JobLocation;
cmd.Parameters.Add("@SupervisorID", SqlDbType.NVarChar).Value = hR_JobPosting.SupervisorID;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_JobPosting.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_JobPosting.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public HR_JobPosting GetHR_JobPostingFromReader(IDataReader reader)
{
try
{
HR_JobPosting hR_JobPosting = new HR_JobPosting
(
DataAccessObject.IsNULL<int>(reader["JobPostingID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<int>(reader["DepartmentID"]),
DataAccessObject.IsNULL<int>(reader["DesignationID"]),
DataAccessObject.IsNULL<DateTime>(reader["JoinDate"]),
DataAccessObject.IsNULL<DateTime>(reader["EndDate"]),
DataAccessObject.IsNULL<string>(reader["PostingStatus"]),
DataAccessObject.IsNULL<string>(reader["JobLocation"]),
DataAccessObject.IsNULL<string>(reader["SupervisorID"].ToString()),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_JobPosting;
}
catch(Exception ex)
{
return null;
}
}
private void showHR_JobPostingData()
{
HR_JobPosting hR_JobPosting = new HR_JobPosting ();
hR_JobPosting = HR_JobPostingManager.GetHR_JobPostingByJobPostingID(Int32.Parse(Request.QueryString["ID"]));
ddlDepartmentID.SelectedValue =hR_JobPosting.DepartmentID.ToString();
ddlDesignationID.SelectedValue =hR_JobPosting.DesignationID.ToString();
txtJoinDate.Text =hR_JobPosting.JoinDate.ToString();
txtEndDate.Text =hR_JobPosting.EndDate.ToString();
txtPostingStatus.Text =hR_JobPosting.PostingStatus.ToString();
txtJobLocation.Text =hR_JobPosting.JobLocation.ToString();
ddlSupervisorID.SelectedValue =hR_JobPosting.SupervisorID.ToString();
}
