public static HR_PostingInformation GetHR_PostingInformationByPostingInformationID(int PostingInformationID) { HR_PostingInformation hR_PostingInformation = new HR_PostingInformation(); SqlHR_PostingInformationProvider sqlHR_PostingInformationProvider = new SqlHR_PostingInformationProvider(); hR_PostingInformation = sqlHR_PostingInformationProvider.GetHR_PostingInformationByPostingInformationID(PostingInformationID); return hR_PostingInformation; }
public static HR_PostingInformation GetHR_EmployeeByEmployeeID(string EmployeeID) { HR_PostingInformation hR_PostingInformation = new HR_PostingInformation(); SqlHR_PostingInformationProvider sqlHR_PostingInformationProvider = new SqlHR_PostingInformationProvider(); hR_PostingInformation = sqlHR_PostingInformationProvider.GetHR_PostingInformationByEmployeeID(EmployeeID); return hR_PostingInformation; }
public static int InsertHR_PostingInformation(HR_PostingInformation hR_PostingInformation) { SqlHR_PostingInformationProvider sqlHR_PostingInformationProvider = new SqlHR_PostingInformationProvider(); return sqlHR_PostingInformationProvider.InsertHR_PostingInformation(hR_PostingInformation); }
public static bool UpdateHR_PostingInformation(HR_PostingInformation hR_PostingInformation) { SqlHR_PostingInformationProvider sqlHR_PostingInformationProvider = new SqlHR_PostingInformationProvider(); return sqlHR_PostingInformationProvider.UpdateHR_PostingInformation(hR_PostingInformation); }
public bool UpdateHR_PostingInformation(HR_PostingInformation hR_PostingInformation) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_PostingInformation", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@PostingInformationID", SqlDbType.Int).Value = hR_PostingInformation.PostingInformationID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_PostingInformation.EmployeeID; cmd.Parameters.Add("@Department", SqlDbType.NVarChar).Value = hR_PostingInformation.Department; cmd.Parameters.Add("@Designation", SqlDbType.NVarChar).Value = hR_PostingInformation.Designation; cmd.Parameters.Add("@JobLocation", SqlDbType.NVarChar).Value = hR_PostingInformation.JobLocation; cmd.Parameters.Add("@Supervisor", SqlDbType.NVarChar).Value = hR_PostingInformation.Supervisor; cmd.Parameters.Add("@JoningDate", SqlDbType.DateTime).Value = hR_PostingInformation.JoningDate; cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = hR_PostingInformation.Status; cmd.Parameters.Add("@FindingDate", SqlDbType.DateTime).Value = hR_PostingInformation.FindingDate; cmd.Parameters.Add("@PostingDate", SqlDbType.DateTime).Value = hR_PostingInformation.PostingDate; cmd.Parameters.Add("@JobResponsibily", SqlDbType.NVarChar).Value = hR_PostingInformation.JobResponsibily; cmd.Parameters.Add("@JobResponsibily", SqlDbType.NVarChar).Value = hR_PostingInformation.JobResponsibily; cmd.Parameters.Add("@JobResponsibily", SqlDbType.NVarChar).Value = hR_PostingInformation.JobResponsibily; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_PostingInformation.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_PostingInformation.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_PostingInformation GetHR_PostingInformationFromReader(IDataReader reader) { try { HR_PostingInformation hR_PostingInformation = new HR_PostingInformation ( DataAccessObject.IsNULL<int>(reader["PostingInformationID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<string>(reader["Department"]), DataAccessObject.IsNULL<string>(reader["Designation"]), DataAccessObject.IsNULL<string>(reader["JobLocation"]), DataAccessObject.IsNULL<string>(reader["Supervisor"]), DataAccessObject.IsNULL<DateTime>(reader["JoningDate"]), DataAccessObject.IsNULL<string>(reader["Status"]), DataAccessObject.IsNULL<DateTime>(reader["FindingDate"]), DataAccessObject.IsNULL<DateTime>(reader["PostingDate"]), DataAccessObject.IsNULL<string>(reader["JobResponsibily"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_PostingInformation; } catch(Exception ex) { return null; } }