public bool EditPostReport(ReportVM r)
{
r.ModifiedBy = 1;
r.ModifiedDate = DateTime.Now;
bool flag = false;
if (r.ReportUrl == null)
{
r.ReportUrl = ExcellentMarketResearch.Areas.Admin.Models.Common.GenerateSlug(r.ReportTitle) + "-" + r.ReportId;
}
if (IsSameReportData(r))
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
var report = serializer.Serialize(r);
ReportMaster repo = serializer.Deserialize <ReportMaster>(report);
repo.LongDescritpion = r.FullDescription;
repo.SinglePrice = r.PriceSingleUser;
repo.MultiUserPrice = r.PriceMultiUser;
repo.CorporateUserPrice = r.PriceCUL;
repo.NumberOfPages = r.NumberOfPage;
repo.PublishereId = r.PublisherId;
repo.ReportDeliveryTypeId = r.DeliveryTypeId;
db.Entry(repo).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
else
{
flag = false;
}
return(flag);
}
public JsonResult GetSaleDetail(int id)
{
var sale = rpsale.Find(id);
List <SaleDetailInfo> infoList = new List <SaleDetailInfo>();
var detailList = rpsaledetails.GetListWithQuery(x => x.SaleID == sale.ID);
foreach (var item in detailList)
{
var itemInfoList = rpsaledetailinfo.GetListWithQuery(x => x.SaleDetailID == item.ID);
infoList.AddRange(itemInfoList);
}
List <string> imeiList = new List <string>();
foreach (var item in infoList)
{
imeiList.Add(item.IMEI);
}
var vm = new ReportVM
{
PaymentType = sale.PaymentType,
SaleDate = sale.AddDate.ToLongDateString(),
SaleTime = String.Format("{0:HH:mm}", sale.AddDate),
AdminUserName = rpadminuser.Find(sale.UserID).FullName,
InvoiceDate = sale.InvoiceDate.Value.ToLongDateString(),
ImeiList = imeiList
};
return(Json(vm, JsonRequestBehavior.AllowGet));
}
public bool EditPostReport(ReportVM r)
{
r.ModifiedBy = 1;
r.ModifiedDate = DateTime.Now;
bool flag = false;
if (r.ReportUrl == null)
{
r.ReportUrl = ModernMarketResearch.Areas.Admin.Models.Common.GenerateSlug(r.ReportTitle) + "-" + r.ReportId;
}
if (IsSameReportData(r))
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
var report = serializer.Serialize(r);
ReportMaster repo = serializer.Deserialize <ReportMaster>(report);
db.Entry(repo).State = EntityState.Modified;
db.SaveChanges();
flag = true;
}
else
{
flag = false;
}
return(flag);
}
// GET: ReportVM
public ActionResult Report()
{
List <ReportVM> CustomerVMlist = new List <ReportVM>();
var customerlist = (from Cust in db.Plaintiffs
join Ord in db.Cases on Cust.PlaintiffID equals Ord.PlaintiffID
join judg in db.CaseJudges on Ord.CaseID equals judg.CaseID
select new
{
Cust.PlaintiffID,
Ord.CaseID,
judg.CaseStatus
}).ToList();
foreach (var item in customerlist)
{
ReportVM objcvm = new ReportVM(); // ViewModel
objcvm.PlaintiffID = item.PlaintiffID;
objcvm.CaseID = item.CaseID;
objcvm.CaseStatus = item.CaseStatus;
CustomerVMlist.Add(objcvm);
}
return(View(CustomerVMlist));
}
public ReportPage(Report report)
{
InitializeComponent();
ViewModel = new ReportVM(report);
BindingContext = ViewModel;
Title = report.ClientName;
ToolbarItems.Add(new ToolbarItem("Share", "share.png", async() => {
var page = new ContentPage();
var result = await page.DisplayAlert("Share Report", "Would you like to share this report?", "Yes", "No");
if (result)
{
if (CrossConnectivity.IsSupported && CrossConnectivity.Current.IsConnected)
{
if (!await ViewModel.SendReportToServer(report))
{
await page.DisplayAlert("Oops!", "There was a problem sending the report to the server. Please try again", "OK");
}
}
else if (CrossConnectivity.IsSupported && !CrossConnectivity.Current.IsConnected)
{
await page.DisplayAlert("Connection Error", "It appears that you aren't connected to the internet. Please check your internet" +
" connection and try again", "OK");
}
}
}));
}
public async Task <IActionResult> CalculateAsync()
{
var data = JsonConvert.DeserializeObject <RequestHoursVM>((string)TempData["modelData"]);
ReportVM model = null;
RequestHoursAM request = new RequestHoursAM {
Identification = data.Identification, Week = data.Week
};
var apiEndpoint = Configuration["ApiEndpoint"];
var apiClient = new HttpClient();
HttpContent content = new StringContent(JsonConvert.SerializeObject(request), Encoding.UTF8, "application/json");
var response = await apiClient.PostAsync(apiEndpoint + "/api/Report/CalculateHours", content);
if (response.IsSuccessStatusCode)
{
var strJson = await response.Content.ReadAsStringAsync();
var deserialize = JsonConvert.DeserializeObject <ReportAM>(strJson);
model = new ReportVM
{
NormalHours = deserialize.NormalHours,
SundayHours = deserialize.SundayHours,
NightHours = deserialize.NightHours,
NormalOvertime = deserialize.NormalOvertime,
NightOvertime = deserialize.NightOvertime,
SundayOvertime = deserialize.SundayOvertime
};
}
return(View(model));
}
public void DeleteTest()
{
Report v = new Report();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Temperature = 36;
context.Set <Report>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(ReportVM));
ReportVM vm = rv.Model as ReportVM;
v = new Report();
v.ID = vm.Entity.ID;
vm.Entity = v;
_controller.Delete(v.ID.ToString(), null);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(context.Set <Report>().Count(), 0);
}
}
public ActionResult EditMentorsReport(Guid id)
{
try
{
ReportVM reportVM = PLAutomapper.Mapper.Map <ReportVM>(_reportLogic.GetById(id));
if (!reportVM.MentorsId.HasValue)
{
return(new HttpStatusCodeResult(403));
}
int requestersId = int.Parse(User.Identity.Name);
if (reportVM.MentorsId != requestersId)
{
return(new HttpStatusCodeResult(403));
}
if (!reportVM.IsDraft)
{
return(new HttpStatusCodeResult(404));
}
return(View(reportVM));
}
catch (Exception e)
{
_customLogger.RecordError(e);
return(new HttpStatusCodeResult(500));
}
}
public int Save(ReportVM report)
{
report.ReportArName = new ArabicPrepocessor().StripArabicWords(report.ReportArName);
report.ReportEnName = new ArabicPrepocessor().StripArabicWords(report.ReportEnName);
report.ReportFrName = new ArabicPrepocessor().StripArabicWords(report.ReportFrName);
return(_repo.Save(report));
}
public JsonResult DashboarData()
{
var NumberMessage = db.Chats.Where(h => h.IsSent == true).ToList();
var Dateonly = NumberMessage.Select(h => h.CreatedDate).Distinct();
var Lecture = db.Users.Where(h => h.Role.id == 2).ToList();
// var MesageToLect = db.Chats.Where(h)
var MessageLast7Days = new List <ReportVM>();
foreach (var item in Dateonly)
{
var date = item.ToString();
date = date.Substring(0, 10);
ReportVM model = new ReportVM();
model.DateString = date;
model.MessageCount = NumberMessage.Count(h => h.CreatedDate == item);
MessageLast7Days.Add(model);
}
var LectCount = new List <LectMessageCountVM>();
foreach (var item in Lecture)
{
var MessageToLect = db.Chats.Where(h => h.ReceivePersonId == item.id && h.IsSent == true).ToList();
LectMessageCountVM model = new LectMessageCountVM();
model.Name = item.Profile.Name;
model.Count = MessageToLect.Count(h => h.ReceivePersonId == item.id);
LectCount.Add(model);
}
Summary list = new Summary();
list.Report = MessageLast7Days;
list.Lecture = LectCount;
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult AllClientReports(int reqId) // Gets all reports for a given request
{
var reports = _db.Reports.Where(r => r.RequestId == reqId);
List <ReportVM> PageReports = new List <ReportVM>();
foreach (var r in reports)
{
var tempRep = new ReportVM
{
RequestNum = r.RequestId.ToString(),
Title = r.Name,
BriefNotes = r.Notes.Substring(0, 25),
Date = r.ReportDate,
RepId = r.ProgressReportId
};
if (r.Notes.Length > tempRep.BriefNotes.Length)
{
tempRep.BriefNotes += "...";
}
PageReports.Add(tempRep);
}
return(View(PageReports));
}
public Report()
{
InitializeComponent();
CurrentVM = new ReportVM();
CurrentVM.ViewService = (IAddReportViewService)this;
DataContext = CurrentVM;
}
public ActionResult ReportManager()
{
List <ReportVM> Report = new List <ReportVM>();
var customerlist = (from plaintiff in db.Plaintiffs
join caselist in db.Cases on plaintiff.PlaintiffID equals caselist.PlaintiffID
join judg in db.CaseJudges on caselist.CaseID equals judg.CaseID
select new
{
plaintiff.PlaintiffID,
caselist.CaseID,
caselist.Date,
caselist.CaseType,
judg.CaseStatus,
judg.JudgmentDate
}).ToList();
foreach (var item in customerlist)
{
ReportVM report = new ReportVM(); // ViewModel
report.PlaintiffID = item.PlaintiffID;
report.CaseID = item.CaseID;
report.CaseRegDate = item.Date;
report.CaseType = item.CaseType;
report.CaseStatus = item.CaseStatus;
report.JudgmentDate = item.JudgmentDate;
Report.Add(report);
}
return(View(Report));
}
public void EditTest()
{
Report v = new Report();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.Temperature = 36;
context.Set <Report>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(ReportVM));
ReportVM vm = rv.Model as ReportVM;
v = new Report();
v.ID = vm.Entity.ID;
v.Temperature = 44;
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.Temperature", "");
_controller.Edit(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <Report>().FirstOrDefault();
Assert.AreEqual(data.Temperature, 44);
}
}
public IActionResult Get([FromRoute] string orgRoleId, [FromRoute] string reportId)
{
if (string.IsNullOrWhiteSpace(orgRoleId) || string.IsNullOrEmpty(orgRoleId))
{
return(StatusCode(StatusCodes.Status400BadRequest,
new BadRequestError($"'{nameof(orgRoleId)}' cannot be null or whitespace")));
}
if (string.IsNullOrWhiteSpace(reportId) || string.IsNullOrEmpty(reportId))
{
return(StatusCode(StatusCodes.Status400BadRequest,
new BadRequestError($"'{nameof(reportId)}' cannot be null or whitespace")));
}
OrganizationRole organizationRole = organizationRoleService
.Get <OrganizationRole>(orgRole => orgRole.Id == orgRoleId, asNoTracking: true);
if (organizationRole == null)
{
return(StatusCode(StatusCodes.Status404NotFound, new NotFoundError($"organizationRole not found")));
}
ReportVM reportVM = reportService.Get <ReportVM>(
report => report.Id == reportId,
asNoTracking: true,
r => r.CreatedBy);
if (reportVM == null)
{
return(StatusCode(StatusCodes.Status404NotFound, new NotFoundError($"report not found")));
}
return(StatusCode(StatusCodes.Status200OK, reportVM));
}
public static ReportVM GetCorrectMentorsReportVM()
{
ReportVM report = GetCorrectInternsReportVM();
report.MentorsId = 2;
return(report);
}
public ActionResult PaymentTypeWiseBankTransaction(ReportVM model)
{
ViewBag.Title = "Payment Wise Bank Transaction Report";
logger.Info("Payment Wise Bank Transaction Report Access");
if (!PermissionControl.CheckPermission(UserAppPermissions.PaymentTypeWiseBankTransactionReport_View))
{
logger.Info("Don't have rights to access Payment Wise Bank Transaction Report");
return(RedirectToAction("Restricted", "Home"));
}
if (model != null)
{
DateTime frdate = DateTime.Now;
if (!string.IsNullOrWhiteSpace(model.FromDate))
{
frdate = DateTime.Parse(model.FromDate);
}
DateTime tdate = DateTime.Now;
if (!string.IsNullOrWhiteSpace(model.ToDate))
{
tdate = DateTime.Parse(model.ToDate);
}
if (string.IsNullOrEmpty(model.PaymentType))
{
model.PaymentType = "ach,wire";
}
logger.DebugFormat("Getting Payment Wise Bank Transaction Report with From Date [{0}] and To Date [{1}] and Payment Type [{2}]", frdate.ToShortDateString(), tdate.ToShortDateString(), model.PaymentType);
ReportViewer reportViewer = new ReportViewer();
try
{
ReportParameter rp = new ReportParameter("ReportDates", string.Format("Date: {0} - {1}", frdate.ToShortDateString(), tdate.ToShortDateString()));
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.SizeToReportContent = true;
reportViewer.Width = Unit.Percentage(100);
reportViewer.Height = Unit.Percentage(100);
reportViewer.ZoomMode = ZoomMode.Percent;
reportViewer.ShowZoomControl = true;
reportViewer.AsyncRendering = false;
reportViewer.ShowPrintButton = true;
var data = bankTransactionManagement.PaymentTypeWiseBankTransaction(frdate, tdate, model.PaymentType);
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + "/Reports/BankTransactionPaymentTypeWise.rdlc";
reportViewer.LocalReport.SetParameters(new ReportParameter[] { rp });
reportViewer.LocalReport.DataSources.Add(new ReportDataSource("BankTransactionPaymentTypeWise", data));
}
catch (Exception ex)
{
logger.ErrorFormat("Exception Raised : Message[{0}] Stack Trace [{1}] ", ex.Message, ex.StackTrace);
}
ViewBag.ReportViewer = reportViewer;
logger.Info("Payment Wise Bank Transaction Report Successfully Accessed");
}
return(View(model));
}
public int Save(ReportVM report)
{
var _rep = (from rep in Context.Reports
where rep.ThemeID == report.ThemeID &&
string.IsNullOrEmpty(report.ReportEnName) || rep.ReportEnName == report.ReportEnName &&
string.IsNullOrEmpty(report.ReportArName) || rep.ReportArName == report.ReportArName &&
string.IsNullOrEmpty(report.ReportFrName) || rep.ReportFrName == report.ReportFrName &&
rep.ReportID != report.ReportID
select rep).FirstOrDefault();
if (_rep != null)
{
return(0);
}
if (report.ReportID > 0)
{
_rep = (from th in Context.Reports
where th.ThemeID == report.ThemeID && th.ReportID == report.ReportID
select th).FirstOrDefault();
_rep.ReportEnName = report.ReportEnName;
_rep.ReportArName = report.ReportArName;
_rep.ReportFrName = report.ReportFrName;
_rep.Source = report.Source;
_rep.SourceAr = report.SourceAr;
_rep.SourceFr = report.SourceFr;
_rep.PublishYear = report.PublishYear;
_rep.ThemeID = report.ThemeID;
_rep.YearTo = report.YearTo;
Context.Reports.Attach(_rep);
Context.Entry(_rep).State = EntityState.Modified;
}
else
{
Report repor = new Report
{
ReportID = report.ReportID,
ReportEnName = report.ReportEnName,
ReportArName = report.ReportArName,
ReportFrName = report.ReportFrName,
Source = report.Source,
SourceAr = report.SourceAr,
SourceFr = report.SourceFr,
ThemeID = report.ThemeID,
RunningVariableID = report.RunningVariableID,
changingVariableID = report.changingVariableID,
YearTo = report.YearTo
};
Context.Reports.Add(repor);
}
int affectedRows = Context.SaveChanges();
return(affectedRows);
}
public async Task <IActionResult> ReportMessageAsync(ReportVM report)
{
var reportDTO = mapper.Map <ReportDTO>(report);
reportDTO.Reporter.Id = GetCurrentUserId();
await messageService.ReportMessageAsync(reportDTO);
return(NoContent());
}
public NewReportView()
{
InitializeComponent();
CurrentVM = new ReportVM();
this.DataContext = CurrentVM;
SaveButton.IsEnabled = false;
TimeDatePicker.Text = DateTime.Now.ToString();
PredictionAndRealFalls = AssessmentAndlFallsVM.Instance;
}
// GET: Report
public ActionResult Index()
{
ReportVM report = new ReportVM();
report.Carts = db.Carts.ToList();
report.Payouts = db.PayOuts.ToList();
report.Transactions = db.TransactionRecords.ToList();
return(View(report));
}
public Information()
{
InitializeComponent();
CurrentReportVM = new ReportVM();
CurrentFallPredictionVM = new AssessmentVM();
DataContext = this;
fallLocation = "";
CalculatedLocation = "";
ReportsNumber = 0;
}
public IActionResult Index()
{
var ReportVM = new ReportVM();
ReportVM.ListEmployees = adamUnit.EmployeeRepository.GetAllInclude().ToList();
ReportVM.ListCustomers = adamUnit.CustomerRepository.GetAll().Select(x => x.ToModel()).ToList();
ReportVM.ListProjects = adamUnit.ProjectRepository.GetAll().Select(x => x.ToModelRep()).ToList();
ReportVM.ListTasks = adamUnit.TaskRepository.GetAll().Select(x => x.ToModel()).ToList();
return(View(ReportVM));
}
public ActionResult PublisherRelatedReports(string puburl, int?pageno)
{
var pubreport = (from r in db.ReportMasters
join p in db.PublisherMasters on r.PublishereId equals p.PublisherId
join c in db.CategoryMasters on r.CategoryId equals c.CategoryId
where p.publisherUrl == puburl
orderby r.CreatedDate
select new ReportVM
{
ReportTitle = r.ReportTitle,
ReportUrl = r.ReportUrl,
CategoryId = r.CategoryId,
CategoryName = c.CategoryName,
ShortCatDesc = c.ShortDescription,
LongCatDesc = c.LongDescription,
PublisherName = p.ContactName,
FullDescription = r.LongDescritpion.Substring(0, 300),
PublishingDate = r.PublishingDate,
PublisherId = r.PublishereId,
CategoryUrl = c.CategoryUrl
}).ToList();
var pubrelatedreport = (from x in pubreport
select new ReportVM
{
ReportTitle = x.ReportTitle,
ReportUrl = x.ReportUrl,
CategoryId = x.CategoryId,
CategoryName = x.CategoryName,
ShortCatDesc = x.ShortCatDesc,
LongCatDesc = x.LongCatDesc,
FullDescription = Regex.Replace(x.FullDescription, @"<[^>]+>| ", "").Trim(),
PublishingDate = x.PublishingDate,
PublisherId = x.PublisherId,
PublisherName = x.PublisherName,
CategoryUrl = x.CategoryUrl,
ReportImage = DDLGetparents(x.CategoryId)
}).ToPagedList(pageno ?? 1, 10);
ReportVM reportvm = new ReportVM();
reportvm = (from p in db.PublisherMasters
where p.publisherUrl == puburl
select new ReportVM
{
LongPublisherDesc = p.LongDescription,
ShortPublisherDesc = p.ShortDescription
}).FirstOrDefault();
//ViewBag.ShortPubDesc = reportvm.ShortPublisherDesc;
//ViewBag.LongPubDesc = reportvm.LongPublisherDesc;
return(View(pubrelatedreport));
}
public Information(Fall CurrentFall)
{
InitializeComponent();
CurrentReportVM = new ReportVM();
CurrentFallPredictionVM = new AssessmentVM();
Location_ Assessmentlocation = GetAssessmentLocationOfFall(CurrentFall);
DataContext = this;
fallLocation = CurrentFall.location.latitude.ToString() + " " + "," + " " + CurrentFall.location.longitude.ToString();
CalculatedLocation = Assessmentlocation.latitude.ToString() + " " + "," + " " + Assessmentlocation.longitude.ToString();
ReportsNumber = CalculateReportNumber(CurrentFall);
}
public static bool IsExistWithSameTitleAndSameDate(ReportVM reportVM)
{
SearchModel searchVM = new SearchModel()
{
Title = reportVM.Title,
DateTo = reportVM.Date,
DateFrom = reportVM.Date,
InternsId = reportVM.InternsId,
MentorsId = reportVM.MentorsId
};
return(_reportLogic.SearchForValidation(searchVM).Any());
}
private void ReportPreview(ReportVM report)
{
if (_selectedReport == null)
{
return;
}
reoGrid.Save($"{Funs.StoreFolder}/temp.xlsx");
var dataRows = LoadDataRow($"{Funs.StoreFolder}/temp.xlsx", reoGrid.CurrentWorksheet.Name);
_report.RegisterData(dataRows, "DataRows");
_designer.InitReport();
_designer.cmdPreview.Invoke();
}
public void InsertReport(ReportVM r)
{
r.CreatedBy = 1;
r.CreatedDate = DateTime.Now;
JavaScriptSerializer serializer = new JavaScriptSerializer();
var s = serializer.Serialize(r);
ReportMaster re = serializer.Deserialize <ReportMaster>(s);
db.ReportMasters.Add(re);
db.SaveChanges();
re.ReportUrl = re.ReportUrl + "-" + re.ReportId;
db.Entry(re).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult Report()
{
var UserRole = CheckUser();
if (UserRole == 1)
{
var _reoprtVM = new ReportVM();
return(View(_reoprtVM));
}
else
{
return(RedirectToAction("Login"));
}
}
public JsonResult GetProductDetails(int id)
{
var expiry = rpsupplierexpiry.Find(id);
var product = rpproduct.Find(expiry.ProductID);
string trademark = rptrademark.Find(product.TradeMarkID).Name;
string model = rpproductmodel.Find(product.ProductModelID).Name;
var pro = new ReportVM()
{
Quantity = expiry.ProductCount,
Price = Calculate(product, expiry.ProductCount),
Note = trademark + " " + model
};
return(Json(pro, JsonRequestBehavior.AllowGet));
}
