public static HR_RetirementRule GetHR_RetirementRuleByRetirementRuleID(int RetirementRuleID) { HR_RetirementRule hR_RetirementRule = new HR_RetirementRule(); SqlHR_RetirementRuleProvider sqlHR_RetirementRuleProvider = new SqlHR_RetirementRuleProvider(); hR_RetirementRule = sqlHR_RetirementRuleProvider.GetHR_RetirementRuleByRetirementRuleID(RetirementRuleID); return hR_RetirementRule; }
public bool UpdateHR_RetirementRule(HR_RetirementRule hR_RetirementRule) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_RetirementRule", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RetirementRuleID", SqlDbType.Int).Value = hR_RetirementRule.RetirementRuleID; cmd.Parameters.Add("@RetirementRuleName", SqlDbType.NVarChar).Value = hR_RetirementRule.RetirementRuleName; cmd.Parameters.Add("@YearOfApplicable", SqlDbType.Int).Value = hR_RetirementRule.YearOfApplicable; cmd.Parameters.Add("@YearOfApplicable", SqlDbType.Int).Value = hR_RetirementRule.YearOfApplicable; cmd.Parameters.Add("@YearOfApplicable", SqlDbType.Int).Value = hR_RetirementRule.YearOfApplicable; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_RetirementRule.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_RetirementRule.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_RetirementRule GetHR_RetirementRuleFromReader(IDataReader reader) { try { HR_RetirementRule hR_RetirementRule = new HR_RetirementRule ( DataAccessObject.IsNULL<int>(reader["RetirementRuleID"]), DataAccessObject.IsNULL<string>(reader["RetirementRuleName"]), DataAccessObject.IsNULL<int>(reader["YearOfApplicable"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_RetirementRule; } catch(Exception ex) { return null; } }
public static bool UpdateHR_RetirementRule(HR_RetirementRule hR_RetirementRule) { SqlHR_RetirementRuleProvider sqlHR_RetirementRuleProvider = new SqlHR_RetirementRuleProvider(); return sqlHR_RetirementRuleProvider.UpdateHR_RetirementRule(hR_RetirementRule); }
public static int InsertHR_RetirementRule(HR_RetirementRule hR_RetirementRule) { SqlHR_RetirementRuleProvider sqlHR_RetirementRuleProvider = new SqlHR_RetirementRuleProvider(); return sqlHR_RetirementRuleProvider.InsertHR_RetirementRule(hR_RetirementRule); }