public static HR_EmployeeRank GetHR_EmployeeRankByEmployeeRankID(int EmployeeRankID) { HR_EmployeeRank hR_EmployeeRank = new HR_EmployeeRank(); SqlHR_EmployeeRankProvider sqlHR_EmployeeRankProvider = new SqlHR_EmployeeRankProvider(); hR_EmployeeRank = sqlHR_EmployeeRankProvider.GetHR_EmployeeRankByEmployeeRankID(EmployeeRankID); return hR_EmployeeRank; }
public static bool UpdateHR_EmployeeRank(HR_EmployeeRank hR_EmployeeRank) { SqlHR_EmployeeRankProvider sqlHR_EmployeeRankProvider = new SqlHR_EmployeeRankProvider(); return sqlHR_EmployeeRankProvider.UpdateHR_EmployeeRank(hR_EmployeeRank); }
public static int InsertHR_EmployeeRank(HR_EmployeeRank hR_EmployeeRank) { SqlHR_EmployeeRankProvider sqlHR_EmployeeRankProvider = new SqlHR_EmployeeRankProvider(); return sqlHR_EmployeeRankProvider.InsertHR_EmployeeRank(hR_EmployeeRank); }
public bool UpdateHR_EmployeeRank(HR_EmployeeRank hR_EmployeeRank) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_EmployeeRank", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EmployeeRankID", SqlDbType.Int).Value = hR_EmployeeRank.EmployeeRankID; cmd.Parameters.Add("@RankName", SqlDbType.NVarChar).Value = hR_EmployeeRank.RankName; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_EmployeeRank.SeniorityLevel; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_EmployeeRank.SeniorityLevel; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_EmployeeRank.SeniorityLevel; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EmployeeRank.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EmployeeRank.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_EmployeeRank(HR_EmployeeRank hR_EmployeeRank) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_EmployeeRank", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EmployeeRankID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@RankName", SqlDbType.NVarChar).Value = hR_EmployeeRank.RankName; cmd.Parameters.Add("@SeniorityLevel", SqlDbType.Int).Value = hR_EmployeeRank.SeniorityLevel; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_EmployeeRank.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_EmployeeRank.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EmployeeRank.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EmployeeRank.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@EmployeeRankID"].Value; } }
public HR_EmployeeRank GetHR_EmployeeRankFromReader(IDataReader reader) { try { HR_EmployeeRank hR_EmployeeRank = new HR_EmployeeRank ( DataAccessObject.IsNULL<int>(reader["EmployeeRankID"]), DataAccessObject.IsNULL<string>(reader["RankName"]), DataAccessObject.IsNULL<int>(reader["SeniorityLevel"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_EmployeeRank; } catch(Exception ex) { return null; } }