private void LpPenjualan_Click(object sender, RoutedEventArgs e)
{
var form = new ReportFilter();
var vm = new ReportFilterViewModel("LAPORAN PENJUALAN")
{
WindowClose = form.Close
};
form.DataContext = vm;
form.ShowDialog();
if (vm.IsValid)
{
var context = new Datas.Contexts.PenjualanContext();
var datas = context.GetDataReportPenjualan().Where(x =>
x.Tanggal.Value.Day >= vm.FromDate.Value.Day &&
x.Tanggal.Value.Month >= vm.FromDate.Value.Month &&
x.Tanggal.Value.Year >= vm.FromDate.Value.Year &&
x.Tanggal.Value.Day <= vm.ToDate.Value.Day &&
x.Tanggal.Value.Month <= vm.ToDate.Value.Month &&
x.Tanggal.Value.Year <= vm.FromDate.Value.Year);
HelperPrint.PrintPreviewWithFormAction("Print Preview",
new ReportDataSource {
Name = "DataSet1", Value = datas
},
"MainApp.Reports.Layouts.LaporanPenjualan.rdlc",
new ReportParameter[] {
new ReportParameter("Dari", vm.FromDate.Value.ToShortDateString()),
new ReportParameter("Sampai", vm.ToDate.Value.ToShortDateString())
});
}
}
public JsonResult ExportExcel([Bind(Include = "interest_area_id,commission_id,status_id,origin_id,period_id")] ReportFilterViewModel filtros)
{
UserBL oUserBL = new UserBL();
var fileName = "Reporte_" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".xlsx";
string errorMessage = "";
filtros.institution_ids = new List <int>();
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_own_institution_support))
{
filtros.institution_ids = oUserBL.ObtenerUser(AuthorizeUserAttribute.UsuarioLogeado().user_id).institution_ids;
}
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_all_institution_support))
{
filtros.institution_ids = null;
}
ConceptBL oConceptBL = new ConceptBL();
oConceptBL.ActualizarTablasReporte(filtros.period_id);
List <ReportViewModel> resultado = oConceptBL.ObtenerExportarReporte(filtros);
// resultado.ForEach(RecalcularCampos);
string fullPath = Path.Combine(Server.MapPath("~/temp"), fileName);
Stream fileBytes = CrearReporteExcel(resultado, fullPath, true);
return(Json(new { fileName = fileName, errorMessage = errorMessage }));
}
public ActionResult CompareReport()
{
ReportFilterViewModel Model = new ReportFilterViewModel();
Model.GetBatchList = _admissionService.GetBatchList().Where(w => w.BatchName != "Batch 0").ToList();
Model.GetReviewList = _perforamnce.GetReViewList().Where(p => p.Name != "Weekly Term").ToList();
Model.MonthList = (from MonthList e in Enum.GetValues(typeof(MonthList))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString()
}).ToList().Where(l => l.Name != "All").ToList();
Model.CompareList = (from CompareType e in Enum.GetValues(typeof(CompareType))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString().Replace('_', ' ')
}).ToList();
Model.MonthQuarterList = (from MonthQurterList e in Enum.GetValues(typeof(MonthQurterList))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString().Replace('_', ',')
}).ToList();
Model.YearList = _report.GetYearList();
return(View(Model));
}
public async Task <IActionResult> GenerateAgingReport(ReportFilterViewModel model)
{
try {
if (!ModelState.IsValid)
{
throw new Exception("Form is not valid!");
}
var userId = new Guid(User.FindFirstValue(ClaimTypes.NameIdentifier));
var result = await _reportBusinessManager.GetAgingReport(model.CompanyId, model.Date, 30, model.NumberOfPeriods, false);
var plan = await _reportBusinessManager.GetSavedPlanReport(userId, model.CompanyId, model.Date);
var viewDataDictionary = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
{ "Plan", _mapper.Map <SavedReportPlanViewModel>(plan) }
};
string html = await _viewRenderService.RenderToStringAsync("_AgingReportPartial", result, viewDataDictionary);
return(Ok(html));
} catch (Exception er) {
return(BadRequest(er.Message ?? er.StackTrace));
}
}
public ActionResult WeeklyReport(int?RegNo)
{
ReportFilterViewModel Model = new ReportFilterViewModel();
Model.GetBatchList = _admissionService.GetBatchList().Where(w => w.BatchName != "Batch 0").ToList();
Model.GetReviewList = _perforamnce.GetReViewList();
Model.MonthList = (from MonthList e in Enum.GetValues(typeof(MonthList))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString()
}).ToList();
Model.YearList = _report.GetYearList();
if (RegNo.HasValue)
{
var info = _report.GetInfoByRegNo(RegNo.Value);
if (info != null)
{
Model.BatchId = info.BatchId.ToString();
Model.RegNo = info.Id;
}
}
Model.ReviewId = 1; // For Weekly Term
Model.WeeklyTermList = _perforamnce.GetWeeklyTermTypeListById(1);
return(View(Model));
}
public async Task <IActionResult> CreatePlan(long id)
{
var companies = await _companyBusinessManager.GetCompanies();
ViewBag.Companies = companies.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
}).ToList();
var savedReportItem = await _reportBusinessManager.GetSavedPlanReport(id);
var model = new ReportFilterViewModel()
{
Date = DateTime.Now.LastDayOfMonth()
};
if (savedReportItem != null)
{
model.Date = savedReportItem.Date;
model.CompanyId = savedReportItem.CompanyId ?? 0;
model.NumberOfPeriods = savedReportItem.NumberOfPeriods;
}
return(View(model));
}
public async Task <IActionResult> CheckAbilityToSaveCredits([FromBody] ReportFilterViewModel model)
{
if (!model.Date.Equals(model.Date.LastDayOfMonth()))
{
return(Ok(false));
}
var company = await _companyBusinessManager.GetCompany(model.CompanyId);
if (company != null && company.Settings != null && company.Settings.SaveCreditValues)
{
var userId = new Guid(User.FindFirstValue(ClaimTypes.NameIdentifier));
var savedReports = await _reportBusinessManager.GetSavedFactReport(userId, model.CompanyId);
if (savedReports == null || savedReports.Count == 0) //Если у компании нет вообще сохраненных репортов, дать возможность сохранить КРЕДИТЫ
{
return(Ok(true));
}
var settings = company.Settings;
var date = model.Date.AddMonths(-1).LastDayOfMonth();
var prevReport = savedReports.Where(x => x.Date == date).FirstOrDefault();
var currentReport = savedReports.Where(x => x.Date == model.Date).FirstOrDefault();
if (settings != null && settings.SaveCreditValues && prevReport != null && prevReport.IsPublished && currentReport == null)
{
return(Ok(true));
}
}
return(Ok(false));
}
// GET: User
public JsonResult ObtenerLista(DataTableAjaxPostModel ofilters, [Bind(Include = "interest_area_id,commission_id,status_id,origin_id,period_id")] ReportFilterViewModel Reportefiltros)//DataTableAjaxPostModel model
{
ConceptBL oConceptBL = new ConceptBL();
UserBL oUserBL = new UserBL();
//ConceptFiltersViewModel ofilters = new ConceptFiltersViewModel();
GridModel <ReportViewModel> grid = new GridModel <ReportViewModel>();
Reportefiltros.institution_ids = new List <int>();
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_own_institution_support))
{
Reportefiltros.institution_ids = oUserBL.ObtenerUser(AuthorizeUserAttribute.UsuarioLogeado().user_id).institution_ids;
}
if (AuthorizeUserAttribute.VerificarPerfil(AuthorizeUserAttribute.Permission.general_report_all_institution_support))
{
Reportefiltros.institution_ids = null;
}
oConceptBL.ActualizarTablasReporte(Reportefiltros.period_id);
grid = oConceptBL.ObtenerReporte(ofilters, Reportefiltros);
grid.rows.ForEach(x => x.age = Helper.CalculateAge(x.birthdate.Value));
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows,
}));
}
public async Task <IActionResult> ExportSettingsView([FromQuery] ReportFilterViewModel model)
{
try {
if (!ModelState.IsValid)
{
throw new Exception("Form is not valid!");
}
var company = await _companyBusinessManager.GetCompany(model.CompanyId);
if (company == null)
{
return(NotFound());
}
//var periods = await _nsiBusinessManager.GetReportPeriods();
var settings = await _companyBusinessManager.GetAllExportSettings(company.Id);
var viewDataDictionary = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
{ "Settings", _mapper.Map <List <CompanyExportSettingsViewModel> >(settings) }
};
string html = await _viewRenderService.RenderToStringAsync("_ExportSettingsPartial", model, viewDataDictionary);
return(Ok(html));
} catch (Exception er) {
return(BadRequest(er.Message ?? er.StackTrace));
}
}
public async Task <List <SavedReportListViewModel> > GetSavedReportPlanList([FromQuery] ReportFilterViewModel model)
{
var companies = await _companyBusinessManager.GetCompanies();
var userId = new Guid(User.FindFirstValue(ClaimTypes.NameIdentifier));
var list = await _reportBusinessManager.GetSavedPlanReport(userId);
var result = list.GroupBy(x => x.CompanyId, x => x.Name, (companyId, names) => new {
Key = companyId ?? 0,
Count = names.Count(),
Name = names.First()
}).Select(x => new SavedReportListViewModel()
{
Name = x.Name,
CompanyId = x.Key,
Count = x.Count
}).ToList();
var planCompanies = companies.Where(x => !result.Any(y => y.CompanyId == x.Id)).ToList();
if (planCompanies.Count > 0)
{
result.AddRange(planCompanies.Select(x => new SavedReportListViewModel()
{
Name = x.Name,
CompanyId = x.Id,
Count = 0
}));
}
return(result);
}
public async Task <IActionResult> CustomerCreditUtilizedSettingsView([FromQuery] ReportFilterViewModel model)
{
try {
if (!ModelState.IsValid)
{
throw new Exception("Form is not valid!");
}
var company = await _companyBusinessManager.GetCompany(model.CompanyId);
var creditUtilizedSettings = await _businessManager.GetCustomerCreditUtilizedSettings(model.CompanyId, model.Date);
model.RoundType = creditUtilizedSettings == null ? company.Settings.RoundType : creditUtilizedSettings.RoundType;
var report = await _reportBusinessManager.GetAgingReport(model.CompanyId, model.Date, 30, model.NumberOfPeriods, false);
var creditUtilizedList = new List <CustomerCreditUtilizedViewModel>();
foreach (var data in report.Rows)
{
var customer = data.Customer;
var creditUtilizeds = await _businessManager.GetCustomerCreditUtilizeds(customer.Id);
var creditUtilized = creditUtilizeds
.OrderByDescending(x => x.CreatedDate)
.Where(x => x.CreatedDate <= model.Date).FirstOrDefault();
if (creditUtilized != null && creditUtilized.IsIgnored)
{
var value = data.Data["Total"];
if (model.RoundType == Core.Data.Enum.RoundType.RoundUp)
{
value = Math.Ceiling(value);
}
else if (model.RoundType == Core.Data.Enum.RoundType.RoundDown)
{
value = Math.Floor(value);
}
if (creditUtilized.Value < value)
{
creditUtilizedList.Add(_mapper.Map <CustomerCreditUtilizedViewModel>(creditUtilized));
}
}
}
creditUtilizedList = creditUtilizedList.OrderBy(x => x.CreatedDate == model.Date).ToList();
var viewDataDictionary = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
{ "CreditUtilizedList", _mapper.Map <List <CustomerCreditUtilizedViewModel> >(creditUtilizedList) }
};
string html = await _viewRenderService.RenderToStringAsync("_CreateCustomerCreditsPartial", model, viewDataDictionary);
return(Ok(html));
} catch (Exception er) {
return(BadRequest(er.Message ?? er.StackTrace));
}
}
public async Task <HttpResponseMessage> GenerateReportEvents(DateTime startDate, DateTime endDate)
{
var filter = new ReportFilterViewModel {
StartDate = startDate, EndDate = endDate
};
return(await Http.PostAsJsonAsync <ReportFilterViewModel>("ReportEvents", filter).ConfigureAwait(false));
}
public FileResult ExportServerSalariesMonthlyPercentageReportToExcel(ReportFilterViewModel viewmodel)
{
MemoryStream stream = _exportingService.GetServerSalariesPercentageMothlyReportExcel(viewmodel.Date.Value);
return(File(stream, Constants.ExcelFilesMimeType,
string.Format(Constants.ServerSalariesPercentageReportExcelFileName
, CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(viewmodel.Date.Value.Month)
, viewmodel.Date.Value.Year)));
}
public RevenueReportViewModel GetFilterizeChartData(ReportFilterViewModel filterModel)
{
var RevenueReport = new RevenueReportViewModel();
RevenueReport.BarChartData = GetBarChartData(filterModel);
RevenueReport.DonutChartData = GetDonutChartData(filterModel);
RevenueReport.LineChartData = GetLineChartData(filterModel);
RevenueReport.BarChartRegistrationData = GetBarChartRegistrationData(filterModel);
return RevenueReport;
}
public ActionResult PerformanceReport()
{
ReportFilterViewModel Model = new ReportFilterViewModel();
Model.GetBatchList = _admissionService.GetBatchList().Where(w => w.BatchName != "Batch 0").ToList();
Model.GetReviewList = _perforamnce.GetReViewList().Where(p => p.Name != "Weekly Term").ToList();
Model.GetCourseList = _admissionService.GetCourseList().OrderBy(o => o.CourseName).ToList();
Model.GetParameterList = _report.GetParameterList();
return(View(Model));
}
public IQueryable <PedidoModel> PostFiltrarPedidoModels([FromBody] ReportFilterViewModel model)//long? idEntrega = 0, string idEstado = "all", string fechaDesde = "all", string fechaHasta = "all")
{
var param = ParameterExpression.Parameter(typeof(PedidoModel), "x");
//////PARAMETER of Estado
var lenEstado = Expression.PropertyOrField(param, "Estado");
var bodyEstado = Expression.Equal(lenEstado, Expression.Constant(model.Estado.ToString()));
Expression AllBody = Expression.Equal(Expression.Constant("all"), Expression.Constant("all"));
if (model.Estado != null && !model.Estado.Equals(0))
{
AllBody = Expression.AndAlso(AllBody, bodyEstado);
}
////PARAMETER of NroBarril
if (!model.FechaDesde.Year.Equals(1))
{
//DateTime resultFechaDesde;
//DateTime.TryParse(fechaDesde, out resultFechaDesde);
var lenfechaDesde = Expression.PropertyOrField(param, "fechaPactada");
var bodyfechaDesde = Expression.GreaterThanOrEqual(lenfechaDesde, Expression.Constant(model.FechaDesde));
AllBody = Expression.AndAlso(AllBody, bodyfechaDesde);
}
if (!model.FechaHasta.Year.Equals(1))
{
//DateTime resultFechaHasta;
//DateTime.TryParse(fechaHasta, out resultFechaHasta);
var lenfechaHasta = Expression.PropertyOrField(param, "fechaPactada");
var bodyfechaHasta = Expression.LessThanOrEqual(lenfechaHasta, Expression.Constant(model.FechaHasta));
AllBody = Expression.AndAlso(AllBody, bodyfechaHasta);
}
////PARAMETER of idEntrega
//var lenidEntrega = Expression.PropertyOrField(param, "idEntrega");
//var bodyidEntrega = Expression.Equal(lenidEntrega, Expression.Convert(Expression.Constant(model.idEntrega), typeof(long?)));
////Expression AllBody = Expression.Equal(Expression.Convert(Expression.Constant(idEntrega),typeof(long?)),Expression.Convert(Expression.Constant(idEntrega.Value),typeof(long?)));
//if (model.idEntrega.HasValue)
// AllBody = Expression.AndAlso(AllBody, bodyidEntrega);
Expression <Func <PedidoModel, bool> > lambda = Expression.Lambda <Func <PedidoModel, bool> >(AllBody, new ParameterExpression[] { param });
var result = db.PedidoModels.Where(lambda).Include(x => x.Cliente).Include(y => y.Entrega);
if (model.RazonSocial != null)
{
var result2 = result.Where(x => x.Cliente.RazonSocial.Equals(model.RazonSocial));
result = result2;
}
return(result);
}
public IHttpActionResult PostFiltrarCoccionModel([FromBody] ReportFilterViewModel model)
{
var EstadoBlank = (!model.Estado.HasValue || model.Estado.Value.Equals(0));
var FechaDesdeHastaBlank = (model.FechaDesde.Year == 1 && model.FechaHasta.Year == 1);
var resultQuery = from mov in db.CoccionModels
where (EstadoBlank || model.Estado.Value == mov.Estado) &&
(FechaDesdeHastaBlank || (model.FechaDesde <= mov.Fecha && model.FechaHasta >= mov.Fecha))
select mov;
return(Ok(resultQuery.Include(x => x.Fermentador).Include(x => x.Receta)));
}
public async Task <IActionResult> CreateSavedReportView([FromQuery] ReportFilterViewModel model)
{
try {
if (!ModelState.IsValid)
{
throw new Exception("Form is not valid!");
}
var company = await _companyBusinessManager.GetCompany(model.CompanyId);
if (company == null)
{
return(NotFound());
}
var userId = new Guid(User.FindFirstValue(ClaimTypes.NameIdentifier));
var savedItem = await _reportBusinessManager.GetSavedFactReport(userId, model.CompanyId, model.Date);
if (savedItem != null && savedItem.IsPublished)
{
string html = await _viewRenderService.RenderToStringAsync("_SaveAgingReportPartial", _mapper.Map <SavedReportViewModel>(savedItem));
return(Ok(html));
}
else
{
var result = _mapper.Map <SavedReportViewModel>(savedItem) ?? new SavedReportViewModel()
{
CompanyId = model.CompanyId,
Name = company.Name,
Date = model.Date,
NumberOfPeriods = model.NumberOfPeriods
};
var settings = await _companyBusinessManager.GetAllExportSettings(model.CompanyId);
var checkingCustomerAccountNumber = await _reportBusinessManager.CheckingCustomerAccountNumber(model.CompanyId, model.Date, model.NumberOfPeriods);
var viewDataDictionary = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
{ "Settings", _mapper.Map <List <CompanyExportSettingsViewModel> >(settings) },
{ "CheckingCustomerAccountNumber", _mapper.Map <ReportStatusViewModel>(checkingCustomerAccountNumber) }
};
string html = await _viewRenderService.RenderToStringAsync("_SaveAgingReportPartial", result, viewDataDictionary);
return(Ok(html));
}
} catch (Exception er) {
return(BadRequest(er.Message ?? er.StackTrace));
}
}
public IActionResult Get(ReportFilterViewModel filter)
{
try
{
return(Ok(_reportCore.Find(filter)));
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
return(StatusCode(500, Json(ex.Message)));
}
}
public int[] GetDonutChartData(ReportFilterViewModel filterModel)
{
int RejectedCandidate = 0;
int PendingCandidate = 0;
int AdmissionCandidate = 0;
int[] result = new int[3];
int minYear = DateTime.Now.AddYears(-5).Year;
int currentYear = DateTime.Now.Year;
var registerData = _context.RegistrationMasters.Where(r => r.RegistrationDate.Value.Year >= minYear && r.RegistrationDate.Value.Year <= currentYear).AsQueryable();
var admissionData = _context.AddmissionMasters.Where(a => a.IsActive && (!a.RegistrationMaster.IsMedicalClear.HasValue || a.RegistrationMaster.IsMedicalClear.Value) && a.AddmissionDetails.FirstOrDefault().BatchMaster.IsActive && a.AddmissionDetails.FirstOrDefault().BatchMaster.Name != "Batch 0");
admissionData = admissionData.Where(a => a.AddmissionDate.Value.Year >= minYear && a.AddmissionDate.Value.Year <= currentYear);
if (filterModel.Year > 0)
{
registerData = registerData.Where(d => d.RegistrationDate.Value.Year == filterModel.Year);
admissionData = admissionData.Where(d => d.AddmissionDate.Value.Year == filterModel.Year);
}
if (!string.IsNullOrWhiteSpace(filterModel.CourseId))
{
var courseArr = filterModel.CourseId.Split(',').Select(Int32.Parse).ToList();
if (courseArr.Count > 0)
{
registerData = registerData.Where(t => courseArr.Any(c => c == t.CourseId));
admissionData = admissionData.Where(t => courseArr.Any(c => c == t.CourseId));
}
}
if (!string.IsNullOrEmpty(filterModel.State))
{
registerData = registerData.Where(x => x.PermanentState == filterModel.State);
admissionData = admissionData.Where(x => x.AddressDetails.Any() && x.AddressDetails.FirstOrDefault().PerState == filterModel.State);
if (!string.IsNullOrEmpty(filterModel.City))
{
registerData = registerData.Where(x => x.PermanentCity == filterModel.City);
admissionData = admissionData.Where(x => x.AddressDetails.Any() && x.AddressDetails.FirstOrDefault().PerCity == filterModel.City);
}
}
if (filterModel.Month > 0)
{
registerData = registerData.Where(d => d.RegistrationDate.Value.Month == filterModel.Month);
admissionData = admissionData.Where(d => d.AddmissionDate.Value.Month == filterModel.Month);
}
RejectedCandidate = registerData.Where(r => (r.IsScreenningClear.HasValue && !r.IsScreenningClear.Value) || (r.IsMedicalClear.HasValue && !r.IsMedicalClear.Value)).Count();
PendingCandidate = registerData.Where(r => r.IsActive && (!r.IsScreenningClear.HasValue || !r.IsMedicalClear.HasValue)).Count();
AdmissionCandidate = admissionData.Count();
result[0] = PendingCandidate;
result[1] = RejectedCandidate;
result[2] = AdmissionCandidate;
return result;
}
public ActionResult ExportCategoryPercentagesMonthlyReportToExcel(ReportFilterViewModel viewmodel)
{
if (ModelState.IsValid)
{
MemoryStream stream = _exportingService.GetCategoryPercentagesMonthlyReportExcel(viewmodel.Date.Value);
return(File(stream, Constants.ExcelFilesMimeType,
string.Format(Constants.CategoryPercentagesMonthlyReportExcelFileName
, CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(viewmodel.Date.Value.Month)
, viewmodel.Date.Value.Year)));
}
return(View("CategoryPercentagesMonthlyReport", viewmodel));
}
public async Task <HttpResponseMessage> HttpStart(
[HttpTrigger(AuthorizationLevel.Anonymous, HttpVerbs.POST, Route = "ReportEvents")] HttpRequestMessage req,
[DurableClient] IDurableOrchestrationClient starter,
ILogger log)
{
ReportFilterViewModel filter = await JsonSerializer.DeserializeAsync <ReportFilterViewModel>(await req.Content.ReadAsStreamAsync());
filter.CheckDate();
string instanceId = await starter.StartNewAsync(ReportEvents_Orchestrator, null, filter);
log.LogInformation($"Started orchestration with ID = '{instanceId}'.");
return(starter.CreateCheckStatusResponse(req, instanceId));
}
public ActionResult DashBoard()
{
ReportFilterViewModel Model = new ReportFilterViewModel();
int currDate = Convert.ToInt32(Session["CurrentYear"]);
Model.GetBatchList = _admissionService.GetBatchList().Where(w => w.BatchName != "Batch 0").ToList();
Model.GetReviewList = _perforamnce.GetReViewList();
Model.TotalBatch = _report.GetNumberOfBatch();
Model.TotalCourse = _report.GetNumberOfCourse();
Model.TotalStudent = _report.GetNumberOfStudentBySession(currDate);
Model.BatchRangeArray = _report.GetBatchListArray();
Model.ReviewId = 3;
return(View(Model));
}
public ActionResult ConsolidatedReport()
{
ReportFilterViewModel Model = new ReportFilterViewModel();
Model.GetReviewList = _perforamnce.GetReViewList().Where(p => p.Name != "Weekly Term").ToList();
Model.BatchJson = Newtonsoft.Json.JsonConvert.SerializeObject(_admissionService.GetBatchList().Where(w => w.BatchName != "Batch 0").Select(item => new SemesterMasterViewModel {
Id = item.Id,
BatchName = item.BatchName,
SemesterName = item.BatchName.Split(' ')[1]
}).ToList());
Model.BatchRangeArray = _report.GetBatchListArray();
Model.TotalBatch = _report.GetNumberOfBatch();
return(View(Model));
}
public async Task <IActionResult> CheckingCustomerAccountNumber([FromBody] ReportFilterViewModel model)
{
try {
if (!ModelState.IsValid)
{
throw new Exception("Form is not valid!");
}
var company = await _companyBusinessManager.GetCompany(model.CompanyId);
if (company == null || company.Settings == null || string.IsNullOrEmpty(company.Settings.AccountNumberTemplate))
{
throw new Exception("Please, check company settings! \"Account Number Template\" is not defined. ");
}
var customers = new List <CustomerListViewModel>();
var regex = new Regex(company.Settings.AccountNumberTemplate);
var result = await _reportBusinessManager.GetAgingReport(model.CompanyId, model.Date, 30, model.NumberOfPeriods, false);
foreach (var data in result.Rows)
{
var customer = data.Customer;
var isMatch = regex.IsMatch(customer.No);
if (!isMatch)
{
customers.Add(_mapper.Map <CustomerListViewModel>(customer));
}
}
if (customers.Count == 0)
{
return(Ok($"{result.Rows.Count} {company.Name} customers has valid \"Account Number\" that match the template set in the company settings"));
}
var viewDataDictionary = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
{ "Company", _mapper.Map <CompanyViewModel>(company) },
{ "TotalCustomers", result.Rows.Count }
};
string html = await _viewRenderService.RenderToStringAsync("_CheckingCustomerAccountNumberPartial", customers, viewDataDictionary);
return(Ok(html));
} catch (Exception er) {
return(BadRequest(er.Message ?? er.StackTrace));
}
}
public IEnumerable <GroupByEstilo> PostMovimientosByCliente([FromBody] ReportFilterViewModel model)
{
var result = FiltrarMovimientosModels(model);
var result2 = (from b in result
group b by b.Cliente.RazonSocial into x
select new GroupByEstilo
{
Estilo = x.Key.ToString(),
CantidadBarriles = x.Sum(y => y.TotalBarriles),
CantidadLitros = x.Sum(y => y.TotalLitros)
}).AsEnumerable();
return(result2);
}
public ActionResult RevenueReport()
{
ReportFilterViewModel model = new ReportFilterViewModel
{
GetBatchList = addmissionService.GetBatchList(),
GetCourseList = addmissionService.GetCourseList(),
MonthList = (from MonthList e in Enum.GetValues(typeof(MonthList))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString()
}).ToList(),
YearList = reportService.GetYearList()
};
return(View(model));
}
public ActionResult ServerSalariesMonthlyPercentageReport(ReportFilterViewModel filter, int page = 1)
{
var entities = Enumerable.Empty <ServerSalaryReportViewModel>();
if (TryValidateModel(filter))
{
entities = _serverSalaryReportService.GetServerSalaryMonthlyPercentageReport(filter.Date.Value);
ViewBag.DisplayResults = true;
}
else
{
ViewBag.DisplayResults = false;
}
ViewBag.FilterViewModel = filter;
return(View(entities));
}
public dynamic GetBatchCandidateDataByBatch(ReportFilterViewModel obj)
{
var BatchChartInfo = _context.tblPerformanceParameterTypeResultMasters.Where(a => a.tblPerformanceEntryMaster.ReviewId != 1 && a.tblPerformanceEntryMaster.BatchMaster.Name == obj.BatchId && !a.tblPerformanceParameterResultMasters.FirstOrDefault().IsNotApplicable).AsQueryable();
if (obj.ReviewId > 0)
{
BatchChartInfo = BatchChartInfo.Where(a => a.tblPerformanceEntryMaster.ReviewId == obj.ReviewId);
}
var data = BatchChartInfo.GroupBy(g => g.tblPerformanceEntryMaster.AddmissionMaster.RegistrationNo).Select(item => new
{
RegistrationNo = item.Key,
Fname = item.FirstOrDefault().tblPerformanceEntryMaster.AddmissionMaster.Fname,
Lname = item.FirstOrDefault().tblPerformanceEntryMaster.AddmissionMaster.Lname,
Percentage = Math.Round((item.Sum(s => s.tblPerformanceParameterResultMasters.Sum(a => a.Rating)) * 100) / (item.Count() * 3.00), 2)
}).OrderBy(o => o.Fname).ToList();
return(data);
}
// GET: Report
public ActionResult Index()
{
ReportFilterViewModel model = new ReportFilterViewModel
{
GetBatchList = addmissionService.GetBatchList(),
GetCourseList = addmissionService.GetCourseList(),
MonthList = (from MonthList e in Enum.GetValues(typeof(MonthList))
select new RoleViewModel
{
Id = (int)e,
Name = e.ToString()
}).ToList(),
YearList = reportService.GetYearList(),
};
model.GetLeadSourceList = addmissionService.GetLeadSourceList();
model.PieClickPartName = "General";
return(View(model));
}
