public static HR_Year GetHR_YearByYearID(int YearID) { HR_Year hR_Year = new HR_Year(); SqlHR_YearProvider sqlHR_YearProvider = new SqlHR_YearProvider(); hR_Year = sqlHR_YearProvider.GetHR_YearByYearID(YearID); return hR_Year; }
public bool UpdateHR_Year(HR_Year hR_Year) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_Year", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@YearID", SqlDbType.Int).Value = hR_Year.YearID; cmd.Parameters.Add("@YearStart", SqlDbType.DateTime).Value = hR_Year.YearStart; cmd.Parameters.Add("@YearEnd", SqlDbType.DateTime).Value = hR_Year.YearEnd; cmd.Parameters.Add("@YearEnd", SqlDbType.DateTime).Value = hR_Year.YearEnd; cmd.Parameters.Add("@YearEnd", SqlDbType.DateTime).Value = hR_Year.YearEnd; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_Year.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_Year.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_Year(HR_Year hR_Year) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertHR_Year", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@YearID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@YearStart", SqlDbType.DateTime).Value = hR_Year.YearStart; cmd.Parameters.Add("@YearEnd", SqlDbType.DateTime).Value = hR_Year.YearEnd; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_Year.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_Year.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_Year.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_Year.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@YearID"].Value; } }
public HR_Year GetHR_YearFromReader(IDataReader reader) { try { HR_Year hR_Year = new HR_Year ( DataAccessObject.IsNULL<int>(reader["YearID"]), DataAccessObject.IsNULL<DateTime>(reader["YearStart"]), DataAccessObject.IsNULL<DateTime>(reader["YearEnd"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_Year; } catch(Exception ex) { return null; } }
public static bool UpdateHR_Year(HR_Year hR_Year) { SqlHR_YearProvider sqlHR_YearProvider = new SqlHR_YearProvider(); return sqlHR_YearProvider.UpdateHR_Year(hR_Year); }
public static int InsertHR_Year(HR_Year hR_Year) { SqlHR_YearProvider sqlHR_YearProvider = new SqlHR_YearProvider(); return sqlHR_YearProvider.InsertHR_Year(hR_Year); }