public IHttpActionResult GetAllMembers(int colorCode, DateTime?fromdate, DateTime?todate, int type, int point) { try { List <MemberEntityViewModel> memberListDriver = new List <MemberEntityViewModel>(); List <MemberEntityViewModel> memberListConductor = new List <MemberEntityViewModel>(); IEnumerable <MemberEntityModel> members = new List <MemberEntityModel>(); members = _member.GetAllMembersSP(colorCode, fromdate, todate, type); if (members != null) { foreach (MemberEntityModel member in members) { MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = member.ID; memberView.fullName = String.IsNullOrEmpty(member.FullName) ? String.Empty : member.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(member.TrainingCertificateNo) ? String.Empty : member.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(member.TrainingCenter) ? String.Empty : member.TrainingCenter; memberView.nic = String.IsNullOrEmpty(member.NIC) ? String.Empty : member.NIC; memberView.ntcNo = String.IsNullOrEmpty(member.NTCNo) ? String.Empty : member.NTCNo; memberView.typeCode = member.Code; memberView.total = member.Total == null ? 0 : member.Total.Value; if (point != 0 && memberView.total <= point) { if (member.Code == "Driver") { memberListDriver.Add(memberView); } else { memberListConductor.Add(memberView); } } else if (point == 0) { if (member.Code == "Driver") { memberListDriver.Add(memberView); } else { memberListConductor.Add(memberView); } } } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { memberListDriver = memberListDriver, memberListConductor = memberListConductor, 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 IHttpActionResult GetAllHightsPointMembers(int typeId) { try { List <MemberEntityViewModel> memberListDriver = new List <MemberEntityViewModel>(); List <MemberEntityViewModel> memberListConductor = new List <MemberEntityViewModel>(); List <MeritDashBoardView> deMListCond = new List <MeritDashBoardView>(); List <MeritDashBoardView> deMListDri = new List <MeritDashBoardView>(); IEnumerable <DeMerit> deMeritCond = _demerit.GetAll(z => z.Member.MemberType.Code == "Conductor").ToList(); deMeritCond = deMeritCond.Where(c => c.CreatedDate.Date >= DateTime.Now.Date.AddMonths(-1) && c.CreatedDate <= DateTime.Now.Date).ToList(); foreach (DeMerit deme in deMeritCond) { var a = deMListCond.Find(x => x.memberId == deme.MemberId); if (a == null) { MeritDashBoardView ax = new MeritDashBoardView(); ax.memberId = deme.MemberId; ax.point = deme.MemberDeMerits.Sum(x => x.Point); deMListCond.Add(ax); } else { a.point += deme.MemberDeMerits.Sum(x => x.Point); } } int maxvalc = deMListCond.Count() <= 0 ? 0 : deMListCond.Max(d => d.point); IEnumerable <DeMerit> deMeritDriv = _demerit.GetAll(z => z.Member.MemberType.Code == "Driver").ToList(); deMeritDriv = deMeritDriv.Where(c => c.CreatedDate.Date >= DateTime.Now.Date.AddMonths(-1) && c.CreatedDate <= DateTime.Now.Date).OrderBy(s => s.MemberDeMerits.Sum(a => a.Point)).ToList(); List <MeritDashBoardView> deMList = new List <MeritDashBoardView>(); foreach (DeMerit deme in deMeritDriv) { var a = deMListDri.Find(x => x.memberId == deme.MemberId); if (a == null) { MeritDashBoardView ax = new MeritDashBoardView(); ax.memberId = deme.MemberId; ax.point = deme.MemberDeMerits.Sum(x => x.Point); deMListDri.Add(ax); } else { a.point += deme.MemberDeMerits.Sum(x => x.Point); } } int maxvald = deMListDri.Count() <= 0 ? 0 : deMListDri.Max(d => d.point); deMListCond = maxvalc == 0 ? new List <MeritDashBoardView>() : deMListCond.Where(x => x.point == maxvalc).ToList(); deMListDri = maxvald == 0 ? new List <MeritDashBoardView>() : deMListDri.Where(x => x.point == maxvald).ToList(); if (typeId == 1) { foreach (MeritDashBoardView mDriver in deMListDri) { Member mem = _member.GetAll(x => x.ID == mDriver.memberId).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListDriver.Add(memberView); } } else { foreach (MeritDashBoardView mConduct in deMListCond) { Member mem = _member.GetAll(x => x.ID == mConduct.memberId).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListConductor.Add(memberView); } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { memberListDriver = memberListDriver, memberListConductor = memberListConductor, 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 IHttpActionResult GetAllHightsNoOfComplainMembers(int typeId) { try { List <MemberEntityViewModel> memberListDriver = new List <MemberEntityViewModel>(); List <MemberEntityViewModel> memberListConductor = new List <MemberEntityViewModel>(); IEnumerable <MemberEntityModel> members = new List <MemberEntityModel>(); List <MeritDashBoardView> highDriver = new List <MeritDashBoardView>(); List <MeritDashBoardView> highCond = new List <MeritDashBoardView>(); IEnumerable <Complain> driverComplain = _complain.GetAll(x => x.Member.MemberType.Code == "Driver" && x.ComplainStatus != "Resolve"); IEnumerable <Complain> conductComplain = _complain.GetAll(x => x.Member1.MemberType.Code == "Conductor" && x.ComplainStatus != "Resolve"); foreach (Complain dcomp in driverComplain) { var a = highDriver.Find(x => x.memberId == dcomp.DriverId); if (a == null && dcomp.DriverId != null) { MeritDashBoardView md = new MeritDashBoardView(); md.point = 1; md.memberId = dcomp.DriverId.Value; highDriver.Add(md); } else { a.point++; } } foreach (Complain dcomp in conductComplain) { var a = highCond.Find(x => x.memberId == dcomp.ConductorId); if (a == null && dcomp.ConductorId != null) { MeritDashBoardView md = new MeritDashBoardView(); md.point = 1; md.memberId = dcomp.ConductorId.Value; highCond.Add(md); } else { a.point++; } } int maxcomplain = highDriver.Count() <= 0 ? 0 : highDriver.Max(x => x.point); int maxcomplaincon = highCond.Count() <= 0 ? 0 : highCond.Max(x => x.point); highDriver = highDriver.Where(w => w.point == maxcomplain).ToList(); highCond = highCond.Where(w => w.point == maxcomplaincon).ToList(); if (typeId == 1) { foreach (MeritDashBoardView mDriver in highDriver) { Member mem = _member.GetAll(x => x.ID == mDriver.memberId).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListDriver.Add(memberView); } } else { foreach (MeritDashBoardView mConduct in highCond) { Member mem = _member.GetAll(x => x.ID == mConduct.memberId).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListConductor.Add(memberView); } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { memberListDriver = memberListDriver, memberListConductor = memberListConductor, 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 IHttpActionResult GetAllBestMembers(DateTime date, int type, bool isMonth) { try { List <MemberEntityViewModel> memberListDriver = new List <MemberEntityViewModel>(); List <MemberEntityViewModel> memberListConductor = new List <MemberEntityViewModel>(); IEnumerable <MemberEntityModel> members = new List <MemberEntityModel>(); //members = _member.GetAllMembersSP(0, (DateTime?)null, (DateTime?)null, type); List <Member> membesDateList = new List <Member>(); IEnumerable <Member> memberList = new List <Member>(); memberList = _member.GetAll(z => z.TypeId == type).ToList(); foreach (Member mem in memberList) { int point = 0; IEnumerable <DeMerit> memberDe = _demerit.GetAll(x => x.MemberId == mem.ID).ToList(); if (isMonth) { memberDe = memberDe.Where(x => x.CreatedDate.Date >= date.Date.AddMonths(-1) && x.CreatedDate.Date <= date.Date).ToList(); if (memberDe.Count() < 2) { if (_complain.GetAll(x => x.DriverId == mem.ID || x.ConductorId == mem.ID).Count() < 2) { membesDateList.Add(mem); } } else if (memberDe.Count() == 0) { if (_complain.GetAll(x => x.DriverId == mem.ID || x.ConductorId == mem.ID).Count() < 2) { membesDateList.Add(mem); } } } else { memberDe = memberDe.Where(x => x.CreatedDate.Date >= date.Date.AddYears(-1) && x.CreatedDate.Date <= date.Date).ToList(); if (memberDe.Count() < 2) { if (_complain.GetAll(x => x.DriverId == mem.ID || x.ConductorId == mem.ID).Count() < 2) { membesDateList.Add(mem); } } else if (memberDe.Count() == 0) { if (_complain.GetAll(x => x.DriverId == mem.ID || x.ConductorId == mem.ID).Count() < 2) { membesDateList.Add(mem); } } } } if (members != null) { foreach (Member member in membesDateList) { MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = member.ID; memberView.fullName = String.IsNullOrEmpty(member.FullName) ? String.Empty : member.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(member.TrainingCertificateNo) ? String.Empty : member.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(member.TrainingCenter) ? String.Empty : member.TrainingCenter; memberView.nic = String.IsNullOrEmpty(member.NIC) ? String.Empty : member.NIC; memberView.ntcNo = String.IsNullOrEmpty(member.NTCNo) ? String.Empty : member.NTCNo; memberView.typeCode = member.MemberType.Code; //memberView.total = member.Total == null ? 0 : member.Total.Value; if (member.MemberType.Code == "Driver") { memberListDriver.Add(memberView); } else { memberListConductor.Add(memberView); } } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { memberListDriver = memberListDriver, memberListConductor = memberListConductor, 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 IHttpActionResult GetAllRetnoticeMembers(int colorCode, DateTime?fromdate, DateTime?todate, int type, int point) { try { List <MemberEntityViewModel> memberListDriver = new List <MemberEntityViewModel>(); List <MemberEntityViewModel> memberListConductor = new List <MemberEntityViewModel>(); //members = _member.GetAllMembersSP(colorCode, fromdate, todate, type); //if (members != null) //{ // foreach (MemberEntityModel member in members) // { // MemberEntityViewModel memberView = new MemberEntityViewModel(); // memberView.id = member.ID; // memberView.fullName = String.IsNullOrEmpty(member.FullName) ? String.Empty : member.FullName; // memberView.trainingCertificateNo = String.IsNullOrEmpty(member.TrainingCertificateNo) ? String.Empty : member.TrainingCertificateNo; // memberView.trainingCenter = String.IsNullOrEmpty(member.TrainingCenter) ? String.Empty : member.TrainingCenter; // memberView.nic = String.IsNullOrEmpty(member.NIC) ? String.Empty : member.NIC; // memberView.ntcNo = String.IsNullOrEmpty(member.NTCNo) ? String.Empty : member.NTCNo; // memberView.typeCode = member.Code; // memberView.total = member.Total == null ? 0 : member.Total.Value; // if (point != 0 && memberView.total >= point) // { // if (member.Code == "Driver") // { // memberListDriver.Add(memberView); // } // else // { // memberListConductor.Add(memberView); // } // } // else if (point == 0) // { // if (member.Code == "Driver") // { // memberListDriver.Add(memberView); // } // else // { // memberListConductor.Add(memberView); // } // } // } //} IEnumerable <DeMerit> memberDem = _demerit.GetAll().ToList(); memberDem = memberDem.Where(x => x.CreatedDate.Date >= DateTime.Now.Date.AddMonths(-1) && x.CreatedDate.Date <= DateTime.Now.Date.AddDays(1)).ToList(); List <MeritDashBoardView> meritIdlistDriver = new List <MeritDashBoardView>(); List <MeritDashBoardView> meritIdlistCond = new List <MeritDashBoardView>(); foreach (DeMerit de in memberDem) { if (de.Member.MemberType.Code == "Driver") { IEnumerable <MemberDeMerit> memDe = de.MemberDeMerits.Where(x => x.Merit.ColorCodeId == 1).ToList(); foreach (MemberDeMerit memdem in memDe.Where(z => z.Point != 0)) { var a = meritIdlistDriver.Find(x => x.memberId == de.MemberId && x.id == memdem.MeritId); if (a == null) { MeritDashBoardView md = new MeritDashBoardView(); md.id = memdem.Merit.ID; md.point += memdem.Point; md.memberId = de.MemberId; meritIdlistDriver.Add(md); } else { a.point += memdem.Point; } } } else { IEnumerable <MemberDeMerit> memDe = de.MemberDeMerits.Where(x => x.Merit.ColorCodeId == 1).ToList(); foreach (MemberDeMerit memdem in memDe.Where(z => z.Point != 0)) { var a = meritIdlistCond.Find(x => x.memberId == de.MemberId && x.id == memdem.MeritId); if (a == null) { MeritDashBoardView md = new MeritDashBoardView(); md.id = memdem.Merit.ID; md.point += memdem.Point; md.memberId = de.MemberId; meritIdlistCond.Add(md); } else { a.point += memdem.Point; } } } } List <int> memb = new List <int>(); if (type == 1) { memb = meritIdlistDriver.Where(r => r.point > 2).Select(z => z.memberId).Distinct().ToList(); foreach (int s in memb) { Member mem = _member.GetAll(x => x.ID == s).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListDriver.Add(memberView); } } else { memb = meritIdlistCond.Where(r => r.point > 2).Select(z => z.memberId).Distinct().ToList(); foreach (int s in memb) { Member mem = _member.GetAll(x => x.ID == s).FirstOrDefault(); MemberEntityViewModel memberView = new MemberEntityViewModel(); memberView.id = mem.ID; memberView.fullName = String.IsNullOrEmpty(mem.FullName) ? String.Empty : mem.FullName; memberView.trainingCertificateNo = String.IsNullOrEmpty(mem.TrainingCertificateNo) ? String.Empty : mem.TrainingCertificateNo; memberView.trainingCenter = String.IsNullOrEmpty(mem.TrainingCenter) ? String.Empty : mem.TrainingCenter; memberView.nic = String.IsNullOrEmpty(mem.NIC) ? String.Empty : mem.NIC; memberView.ntcNo = String.IsNullOrEmpty(mem.NTCNo) ? String.Empty : mem.NTCNo; memberView.typeCode = mem.MemberType.Code; memberListConductor.Add(memberView); } } var messageData = new { code = Constant.SuccessMessageCode, message = Constant.MessageSuccess }; var returnObject = new { memberListDriver = memberListDriver, memberListConductor = memberListConductor, 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)); } }