public static HR_ShiftingWorkingDays GetHR_ShiftingWorkingDaysByShiftingWorkingDaysID(int ShiftingWorkingDaysID) { HR_ShiftingWorkingDays hR_ShiftingWorkingDays = new HR_ShiftingWorkingDays(); SqlHR_ShiftingWorkingDaysProvider sqlHR_ShiftingWorkingDaysProvider = new SqlHR_ShiftingWorkingDaysProvider(); hR_ShiftingWorkingDays = sqlHR_ShiftingWorkingDaysProvider.GetHR_ShiftingWorkingDaysByShiftingWorkingDaysID(ShiftingWorkingDaysID); return hR_ShiftingWorkingDays; }
public bool UpdateHR_ShiftingWorkingDays(HR_ShiftingWorkingDays hR_ShiftingWorkingDays) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_ShiftingWorkingDays", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ShiftingWorkingDaysID", SqlDbType.Int).Value = hR_ShiftingWorkingDays.ShiftingWorkingDaysID; cmd.Parameters.Add("@ShiftingWorkingDaysName", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.ShiftingWorkingDaysName; cmd.Parameters.Add("@ShiftStartTime", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.ShiftStartTime; cmd.Parameters.Add("@ShiftEndTime", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.ShiftEndTime; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.Description; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.Description; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.Description; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_ShiftingWorkingDays.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_ShiftingWorkingDays.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_ShiftingWorkingDays GetHR_ShiftingWorkingDaysFromReader(IDataReader reader) { try { HR_ShiftingWorkingDays hR_ShiftingWorkingDays = new HR_ShiftingWorkingDays ( DataAccessObject.IsNULL<int>(reader["ShiftingWorkingDaysID"]), DataAccessObject.IsNULL<string>(reader["ShiftingWorkingDaysName"]), DataAccessObject.IsNULL<string>(reader["ShiftStartTime"]), DataAccessObject.IsNULL<string>(reader["ShiftEndTime"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_ShiftingWorkingDays; } catch(Exception ex) { return null; } }
public static bool UpdateHR_ShiftingWorkingDays(HR_ShiftingWorkingDays hR_ShiftingWorkingDays) { SqlHR_ShiftingWorkingDaysProvider sqlHR_ShiftingWorkingDaysProvider = new SqlHR_ShiftingWorkingDaysProvider(); return sqlHR_ShiftingWorkingDaysProvider.UpdateHR_ShiftingWorkingDays(hR_ShiftingWorkingDays); }
public static int InsertHR_ShiftingWorkingDays(HR_ShiftingWorkingDays hR_ShiftingWorkingDays) { SqlHR_ShiftingWorkingDaysProvider sqlHR_ShiftingWorkingDaysProvider = new SqlHR_ShiftingWorkingDaysProvider(); return sqlHR_ShiftingWorkingDaysProvider.InsertHR_ShiftingWorkingDays(hR_ShiftingWorkingDays); }