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