/// <summary> /// Cập nhật thông tin /// </summary> /// <param name="weekReport"></param> public void Update(WeekReport weekReport) { _context.WeekReports.Attach(weekReport); _context.Entry(weekReport).State = EntityState.Modified; SaveChanges(); }
/// <summary> /// /// </summary> /// <param name="departmentId"></param> /// <param name="departmentName"></param> /// <param name="createdDate"></param> /// <param name="quantity"></param> public void InsertOrUpdateWeekReport( string departmentId, string departmentName, DateTime createdDate, int quantity) { string reportDate = createdDate.Date.ToString("MM-yyyy"); WeekReport weekReport; // Nếu chưa tồn tại thì tạo mới if (CheckWeekReportIdExit(departmentId, reportDate)) { weekReport = new WeekReport() { DepartmentID = departmentId, ReportDate = reportDate, DepartmentName = departmentName, }; const int defaultNull = 0; if (GetWeekNumberOfMonth(createdDate) == 1) { weekReport.Week_1 = quantity > 0 ? quantity : defaultNull; } else if (GetWeekNumberOfMonth(createdDate) == 2) { weekReport.Week_2 = quantity > 0 ? quantity : defaultNull; } else if (GetWeekNumberOfMonth(createdDate) == 3) { weekReport.Week_3 = quantity > 0 ? quantity : defaultNull; } else if (GetWeekNumberOfMonth(createdDate) == 4) { weekReport.Week_4 = quantity > 0 ? quantity : defaultNull; } else if (GetWeekNumberOfMonth(createdDate) == 5) { weekReport.Week_5 = quantity > 0 ? quantity : defaultNull; } try { Add(weekReport); } catch (Exception) { throw new Exception(); } } // Nếu tồn tại rồi thì cập nhật thông tin else { weekReport = GetWeekReportById(departmentId, reportDate); if (GetWeekNumberOfMonth(createdDate) == 1) { weekReport.Week_1 += quantity; } else if (GetWeekNumberOfMonth(createdDate) == 2) { weekReport.Week_2 += quantity; } else if (GetWeekNumberOfMonth(createdDate) == 3) { weekReport.Week_3 += quantity; } else if (GetWeekNumberOfMonth(createdDate) == 4) { weekReport.Week_4 += quantity; } else if (GetWeekNumberOfMonth(createdDate) == 5) { weekReport.Week_5 += quantity; } try { Update(weekReport); } catch (Exception) { throw new Exception(); } } }
/// <summary> /// Thêm mới /// </summary> /// <param name="weekReport"></param> /// <returns></returns> public void Add(WeekReport weekReport) { _context.WeekReports.Add(weekReport); SaveChanges(); }