public static HR_EducatinalBackground GetHR_ReaultSystemByReaultSystemID(int ReaultSystemID) { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground(); SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); hR_EducatinalBackground = sqlHR_EducatinalBackgroundProvider.GetHR_EducatinalBackgroundByReaultSystemID(ReaultSystemID); return hR_EducatinalBackground; }
public static HR_EducatinalBackground GetHR_EducationGroupByEducationGroupID(int EducationGroupID) { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground(); SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); hR_EducatinalBackground = sqlHR_EducatinalBackgroundProvider.GetHR_EducatinalBackgroundByEducationGroupID(EducationGroupID); return hR_EducatinalBackground; }
public static HR_EducatinalBackground GetHR_EmployeeByEmployeeID(string EmployeeID) { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground(); SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); hR_EducatinalBackground = sqlHR_EducatinalBackgroundProvider.GetHR_EducatinalBackgroundByEmployeeID(EmployeeID); return hR_EducatinalBackground; }
public static HR_EducatinalBackground GetHR_BoardUniversityByBoardUniversityID(int BoardUniversityID) { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground(); SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); hR_EducatinalBackground = sqlHR_EducatinalBackgroundProvider.GetHR_EducatinalBackgroundByBoardUniversityID(BoardUniversityID); return hR_EducatinalBackground; }
public static HR_EducatinalBackground GetHR_YearByYearID(int YearID) { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground(); SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); hR_EducatinalBackground = sqlHR_EducatinalBackgroundProvider.GetHR_EducatinalBackgroundByYearID(YearID); return hR_EducatinalBackground; }
public static bool UpdateHR_EducatinalBackground(HR_EducatinalBackground hR_EducatinalBackground) { SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); return sqlHR_EducatinalBackgroundProvider.UpdateHR_EducatinalBackground(hR_EducatinalBackground); }
public static int InsertHR_EducatinalBackground(HR_EducatinalBackground hR_EducatinalBackground) { SqlHR_EducatinalBackgroundProvider sqlHR_EducatinalBackgroundProvider = new SqlHR_EducatinalBackgroundProvider(); return sqlHR_EducatinalBackgroundProvider.InsertHR_EducatinalBackground(hR_EducatinalBackground); }
public bool UpdateHR_EducatinalBackground(HR_EducatinalBackground hR_EducatinalBackground) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_EducatinalBackground", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@EducationalBacgroundID", SqlDbType.Int).Value = hR_EducatinalBackground.EducationalBacgroundID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_EducatinalBackground.EmployeeID; cmd.Parameters.Add("@YearID", SqlDbType.Int).Value = hR_EducatinalBackground.YearID; cmd.Parameters.Add("@BoardUniversityID", SqlDbType.Int).Value = hR_EducatinalBackground.BoardUniversityID; cmd.Parameters.Add("@EducationGroupID", SqlDbType.Int).Value = hR_EducatinalBackground.EducationGroupID; cmd.Parameters.Add("@Major", SqlDbType.NVarChar).Value = hR_EducatinalBackground.Major; cmd.Parameters.Add("@ReaultSystemID", SqlDbType.Int).Value = hR_EducatinalBackground.ReaultSystemID; cmd.Parameters.Add("@Degree", SqlDbType.NVarChar).Value = hR_EducatinalBackground.Degree; cmd.Parameters.Add("@Result", SqlDbType.NVarChar).Value = hR_EducatinalBackground.Result; cmd.Parameters.Add("@Score", SqlDbType.Decimal).Value = hR_EducatinalBackground.Score; cmd.Parameters.Add("@OutOf", SqlDbType.Int).Value = hR_EducatinalBackground.OutOf; cmd.Parameters.Add("@OutOf", SqlDbType.Int).Value = hR_EducatinalBackground.OutOf; cmd.Parameters.Add("@OutOf", SqlDbType.Int).Value = hR_EducatinalBackground.OutOf; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_EducatinalBackground.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_EducatinalBackground.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_EducatinalBackground GetHR_EducatinalBackgroundFromReader(IDataReader reader) { try { HR_EducatinalBackground hR_EducatinalBackground = new HR_EducatinalBackground ( DataAccessObject.IsNULL<int>(reader["EducationalBacgroundID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<int>(reader["YearID"]), DataAccessObject.IsNULL<int>(reader["BoardUniversityID"]), DataAccessObject.IsNULL<int>(reader["EducationGroupID"]), DataAccessObject.IsNULL<string>(reader["Major"]), DataAccessObject.IsNULL<int>(reader["ReaultSystemID"]), DataAccessObject.IsNULL<string>(reader["Degree"]), DataAccessObject.IsNULL<string>(reader["Result"]), DataAccessObject.IsNULL<decimal>(reader["Score"]), DataAccessObject.IsNULL<int>(reader["OutOf"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_EducatinalBackground; } catch(Exception ex) { return null; } }