/// <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();
}
