public FeedbackReportModel GetFeedbackStats(ReportRequestModel feedbackRequestModel, string officerCode)
{
FeedbackReportModel response = new FeedbackReportModel();
using (var imisContext = new ImisDB())
{
var feedbackSent = (from FP in imisContext.TblFromPhone
where FP.DocType == "F" &&
FP.LandedDate >= feedbackRequestModel.FromDate &&
FP.LandedDate <= feedbackRequestModel.ToDate &&
FP.OfficerCode == officerCode
select FP)
.ToList();
var feedbackAccepted = feedbackSent
.Where(f => f.DocStatus == "A")
.Count();
response = new FeedbackReportModel()
{
FeedbackSent = feedbackSent.Count(),
FeedbackAccepted = feedbackAccepted
};
}
return(response);
}
public FeedbackReportModel FeedbackReport()
{
FeedbackReportModel feedbackReport = new FeedbackReportModel();
try
{
using (var mdb = new OggleBoobleMySqContext())
{
feedbackReport.FeedbackRows =
(from f in mdb.FeedBacks
join v in mdb.Visitors on f.VisitorId equals v.VisitorId
join c in mdb.CategoryFolders on f.PageId equals c.Id
join p in mdb.CategoryFolders on c.Parent equals p.Id
join r in mdb.RegisteredUsers on f.VisitorId equals r.VisitorId into sr
from u in sr.DefaultIfEmpty()
where (v.IpAddress != "68.203.90.183")
select new FeedbackModel()
{
IpAddress = v.IpAddress,
Parent = p.FolderName,
Folder = c.FolderName,
FeedBackType = f.FeedBackType,
Occured = f.Occured,
FeedBackComment = f.FeedBackComment,
UserName = u.UserName == null ? "unregistered" : u.UserName,
Email = u.Email == null ? "" : u.Email
}).OrderByDescending(f => f.Occured).ToList();
feedbackReport.Success = "ok";
}
}
catch (Exception ex)
{
feedbackReport.Success = Helpers.ErrorDetails(ex);
}
return(feedbackReport);
}
