public List <DiaryLog> GetDiaryLogsByUserId(int userId) { using (DiaryLogRepository _repo = new DiaryLogRepository()) { return(_repo.GetAll().Where(x => x.UserId == userId).ToList()); } }
public Dictionary <string, string> GetDiaryLogItemsByUserId(int userId) { Dictionary <string, string> diaryLogItemDics = new Dictionary <string, string>(); using (DiaryLogRepository _repo = new DiaryLogRepository()) { var diaryLogItems = _repo.GetAll().Where(x => x.UserId == userId).Select(x => x.DiaryLogItem).Distinct(); foreach (var diaryLogItem in diaryLogItems) { diaryLogItemDics.Add(diaryLogItem, diaryLogItem); } } return(diaryLogItemDics); }
public bool DeleteDiaryLog(int diaryLogId) { bool result = false; using (DiaryLogRepository _repo = new DiaryLogRepository()) { var detail = _repo.GetById(diaryLogId); if (detail != null) { _repo.Delete(detail); result = true; } } return(result); }
public void UpdateDiaryLog(DiaryLog diaryLog, DiaryLog newDiaryLog, DateTime diaryLogDate, string account, int userId) { using (DiaryLogRepository _repo = new DiaryLogRepository()) { diaryLog.DiaryLogItem = newDiaryLog.DiaryLogItem; diaryLog.DiaryLogContents = newDiaryLog.DiaryLogContents; diaryLog.DiaryLogStatus = newDiaryLog.DiaryLogStatus; diaryLog.DiaryLogHours = newDiaryLog.DiaryLogHours; diaryLog.DiaryLogSituation = newDiaryLog.DiaryLogSituation; diaryLog.DiaryLogSolve = newDiaryLog.DiaryLogSolve; diaryLog.UpdateDate = DateTime.Now; diaryLog.UpdateId = account; _repo.Edit(diaryLog); } }
public void ModidDiaryLogy(List <DiaryLog> diaryLogs, DateTime diaryLogDate, string account, int userId) { using (DiaryLogRepository _repo = new DiaryLogRepository()) { foreach (var item in diaryLogs) { DiaryLog diaryLog = _repo.GetById(item.DiaryLogId); if (diaryLog != null) { UpdateDiaryLog(diaryLog, item, diaryLogDate, account, userId); } else { InsertDiaryLog(item, diaryLogDate, account, userId); } } } }
public void InsertDiaryLog(DiaryLog diaryLogs, DateTime diaryLogDate, string account, int userId) { using (DiaryLogRepository _repo = new DiaryLogRepository()) { DiaryLog newDiaryLog = new DiaryLog(); newDiaryLog.DiaryLogDate = diaryLogDate; newDiaryLog.UserId = userId; newDiaryLog.DiaryLogItem = diaryLogs.DiaryLogItem; newDiaryLog.DiaryLogContents = diaryLogs.DiaryLogContents; newDiaryLog.DiaryLogStatus = diaryLogs.DiaryLogStatus; newDiaryLog.DiaryLogHours = diaryLogs.DiaryLogHours; newDiaryLog.DiaryLogSituation = diaryLogs.DiaryLogSituation; newDiaryLog.DiaryLogSolve = diaryLogs.DiaryLogSolve; newDiaryLog.CreateDate = DateTime.Now; newDiaryLog.CreateId = account; newDiaryLog.UpdateDate = DateTime.Now; newDiaryLog.UpdateId = account; _repo.Insert(newDiaryLog); } }