public static HR_SalaryIncrement GetHR_SalaryIncrementBySalaryIncrementID(int SalaryIncrementID) { HR_SalaryIncrement hR_SalaryIncrement = new HR_SalaryIncrement(); SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); hR_SalaryIncrement = sqlHR_SalaryIncrementProvider.GetHR_SalaryIncrementBySalaryIncrementID(SalaryIncrementID); return hR_SalaryIncrement; }
public static HR_SalaryIncrement GetHR_EmployeeByEmployeeID(string EmployeeID) { HR_SalaryIncrement hR_SalaryIncrement = new HR_SalaryIncrement(); SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); hR_SalaryIncrement = sqlHR_SalaryIncrementProvider.GetHR_SalaryIncrementByEmployeeID(EmployeeID); return hR_SalaryIncrement; }
public static int InsertHR_SalaryIncrement(HR_SalaryIncrement hR_SalaryIncrement) { SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); return sqlHR_SalaryIncrementProvider.InsertHR_SalaryIncrement(hR_SalaryIncrement); }
public static bool UpdateHR_SalaryIncrement(HR_SalaryIncrement hR_SalaryIncrement) { SqlHR_SalaryIncrementProvider sqlHR_SalaryIncrementProvider = new SqlHR_SalaryIncrementProvider(); return sqlHR_SalaryIncrementProvider.UpdateHR_SalaryIncrement(hR_SalaryIncrement); }
public bool UpdateHR_SalaryIncrement(HR_SalaryIncrement hR_SalaryIncrement) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_SalaryIncrement", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SalaryIncrementID", SqlDbType.Int).Value = hR_SalaryIncrement.SalaryIncrementID; cmd.Parameters.Add("@SalaryIncrementName", SqlDbType.NVarChar).Value = hR_SalaryIncrement.SalaryIncrementName; cmd.Parameters.Add("@PerYearNoTimes", SqlDbType.Int).Value = hR_SalaryIncrement.PerYearNoTimes; cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryIncrement.Ratio; cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryIncrement.Ratio; cmd.Parameters.Add("@Ratio", SqlDbType.Decimal).Value = hR_SalaryIncrement.Ratio; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_SalaryIncrement.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_SalaryIncrement.ModifiedDate; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_SalaryIncrement.EmployeeID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_SalaryIncrement GetHR_SalaryIncrementFromReader(IDataReader reader) { try { HR_SalaryIncrement hR_SalaryIncrement = new HR_SalaryIncrement ( DataAccessObject.IsNULL<int>(reader["SalaryIncrementID"]), DataAccessObject.IsNULL<string>(reader["SalaryIncrementName"]), DataAccessObject.IsNULL<int>(reader["PerYearNoTimes"]), DataAccessObject.IsNULL<decimal>(reader["Ratio"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()) ); return hR_SalaryIncrement; } catch(Exception ex) { return null; } }