public IHttpActionResult GetAllMerits() { try { List <MemberDeMeritViewModel> meritList = new List <MemberDeMeritViewModel>(); IEnumerable <Merit> merits = new List <Merit>(); merits = _common.GetAllMerits(); foreach (Merit merit in merits) { MemberDeMeritViewModel meritView = new MemberDeMeritViewModel(); meritView.meritId = merit.ID; meritView.code = merit.Code; meritView.description = merit.Description; meritView.colorCode = merit.ColorCodeId; meritView.point = 0; meritList.Add(meritView); } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { merits = meritList, messageCode = messageData }; return(Ok(returnObject)); } catch (Exception ex) { string errorLogId = _eventLog.WriteLogs(User.Identity.Name, ex, MethodBase.GetCurrentMethod().Name); var messageData = new { code = Constant.ErrorMessageCode, message = String.Format(Constant.MessageTaskmateError, errorLogId) }; var returnObject = new { messageCode = messageData }; return(Ok(returnObject)); } }
public IList <MemberDeMeritViewModel> GetDeMeritSummery(int memberId) { try { IList <MemberDeMeritViewModel> memberDemeritView = new List <MemberDeMeritViewModel>(); DateTime fromDate = TimeZoneInfo.ConvertTime(DateTime.Now.AddMonths(-1), TimeZoneInfo.FindSystemTimeZoneById(ConfigurationManager.AppSettings["LocalTimeZone"])); DateTime toDate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById(ConfigurationManager.AppSettings["LocalTimeZone"])); IEnumerable <Merit> merits = _meritRepository.Get().ToList(); foreach (Merit merit in merits) { MemberDeMeritViewModel demerit = new MemberDeMeritViewModel(); demerit.code = merit.Code; demerit.description = merit.Description; IEnumerable <MemberDeMerit> memDeMerit = _memberDeMeritRepository.Get(x => x.MeritId == merit.ID && x.DeMerit.MemberId == memberId).ToList(); demerit.point = memDeMerit.Where(y => y.DeMerit.CreatedDate.Date >= fromDate.Date && y.DeMerit.CreatedDate.Date <= toDate.Date).Sum(z => z.Point); demerit.colorCode = merit.ColorCodeId; memberDemeritView.Add(demerit); } return(memberDemeritView); } catch (Exception ex) { throw ex; } }
public IHttpActionResult GetDemeritByNo(int deMeritNo) { try { DeMeritViewModel deMeritView = new DeMeritViewModel(); DeMerit deMerit = new DeMerit(); deMerit = _deMerit.GetDeMeritByNo(deMeritNo); if (deMerit != null) { deMeritView.id = deMerit.ID; deMeritView.deMeritNo = deMerit.DeMeritNo; deMeritView.inqueryDate = deMerit.InqueryDate.ToString(@"yyyy-MM-dd"); deMeritView.member = new MemberViewModel(); deMeritView.member.id = deMerit.MemberId; deMeritView.member.nameWithInitial = deMerit.Member.ShortName; deMeritView.inqueryDate = deMerit.InqueryDate.ToString(@"yyyy-MM-dd"); deMeritView.officer = new OfficerViewModel(); deMeritView.officer.id = deMerit.Officer.ID; deMeritView.officer.name = deMerit.Officer.Name; deMeritView.bus = new BusViewModel(); deMeritView.bus.id = deMerit.Bus.ID; deMeritView.bus.busNo = deMerit.Bus.LicenceNo; deMeritView.memberDeMerit = new List <MemberDeMeritViewModel>(); foreach (MemberDeMerit merti in deMerit.MemberDeMerits) { MemberDeMeritViewModel demerit = new MemberDeMeritViewModel(); demerit.id = merti.ID; demerit.meritId = merti.MeritId; demerit.code = merti.Merit.Code; demerit.description = merti.Merit.Description; demerit.point = merti.Point; demerit.colorCode = merti.Merit.ColorCodeId; deMeritView.memberDeMerit.Add(demerit); } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { demerit = deMeritView, messageCode = messageData }; return(Ok(returnObject)); } catch (Exception ex) { string errorLogId = _eventLog.WriteLogs(User.Identity.Name, ex, MethodBase.GetCurrentMethod().Name); var messageData = new { code = Constant.ErrorMessageCode, message = String.Format(Constant.MessageTaskmateError, errorLogId) }; var returnObject = new { messageCode = messageData }; return(Ok(returnObject)); } }