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