public ActionResult Index()
{
var user = _userManager.GetUserAsync(GetCurrentUser()).Result;
var category = _db.Category
.Include(a => a.IssueCategory)
.ThenInclude(a => a.Issue)
.Where(a => a.IssueCategory.Any(b => b.Issue.IdServiceUser == user.Id))
.ToList();
var list = _db.Issue
.Include(a => a.User)
.Include(a => a.IssueCategory)
.ThenInclude(a => a.Category)
.Include(a => a.Prioritet)
.Include(a => a.Status)
.Where(i => i.IdServiceUser == user.Id).OrderByDescending(i => i.Date).ToList();
ReportViewModels result = new ReportViewModels()
{
Issues = list.Select(a => new ReportIssueViewModels()
{
Date = a.Date, Name = a.Title
}).ToList(),
ReportItems = category.Select(a => new ReportItemViewModels {
Category = a.Name, CountIssue = a.IssueCategory.Count()
}).ToList()
};
return(View(result));
}
public ActionResult DailyTimeSheet(int id, string date)
{
var concernId = Convert.ToInt32(Session["ConcernId"]);
var userId = Convert.ToInt32(Session["UserId"]);
var userName = Convert.ToString(Session["UserName"]);
if (userId > 0 && concernId > 0)
{
int totalValue = 0;
var sheet = _report.DailyTimeSheet(userName, userId, id, date, "en-US");
foreach (var item in sheet)
{
totalValue = Convert.ToInt32(item.TotalBeforeVat);
}
WordValue value = new WordValue();
var final = value.NumberToWords(totalValue);
//var today = DateTime.Now.ToString("yyyy-MM-dd");
ReportViewModels viewModels = new ReportViewModels
{
ResponseTimeSheets = sheet
};
ViewBag.Value = final;
var report = new PartialViewAsPdf("DailyTimeSheet", viewModels);
return(report);
}
return(RedirectToAction("LogIn", "GlobalData", new { Area = "Global" }));
}
public ActionResult Index()
{
//var searchResults = TwitterSearch.SearchByHashTag("salesforce", 15);
//string chartResults = "['Date', 'Salesforce']";
//var dateKeys = searchResults.Keys.ToList();
//dateKeys.Sort();
//foreach (var key in dateKeys)
//{
// if (!string.IsNullOrEmpty(chartResults))
// {
// chartResults += ",";
// }
// chartResults += ($"['{key:d}', {searchResults[key]}]");
//}
///*
//var keywords = new[]
//{
// new Tuple<string, int>("pepsi", 2000),
// new Tuple<string, int>("coca-cola", 1000)
//};
//*/
var model = new ReportViewModels
{
KeywordsPopularity = ""
};
return(View(model));
}
public ActionResult Index()
{
ReportViewModels model = new ReportViewModels();
model.reportList = reportUnitOfWork.GetAllReport();
return(View(model));
}
public ActionResult Report(string twit_keywor1, string twit_keywor2)
{
Dictionary <DateTime, int>[] searchResults = GetSearchResults(twit_keywor1, twit_keywor2);
var model = new ReportViewModels();
model.KeywordsPopularity = GetDataForLineChart(searchResults[0], searchResults[1], twit_keywor1, twit_keywor2);
model.KeywordsPopularityLineChart = GetDataForColumnCharts(searchResults[0], searchResults[1], twit_keywor1, twit_keywor2);
model.Keyword1 = twit_keywor1;
model.Keyword2 = twit_keywor2;
return(View("Index", model));
}
public ActionResult BDAnalysisSummary(int PlantId, int Year, int Month)
{
var ReportDataSource = this._reportService.GetBDAnalysisSummaryReportData(PlantId, Year, Month);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\BDAnalysisSummary.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult FormulationRequestMonthlySummary(int Year, int Month, int LineId)
{
var ReportDataSource = this._reportService.GetFormulationRequestData(Year, Month, LineId);
ReportViewModels model = new ReportViewModels
{
DataSetName = "FormulationMasterDataSet",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\FormulationMonthlySummary.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult PMAuditReport(int Year, int Month, int Status)
{
var ReportDataSource = this._reportService.GetPMAuditReportData(Year, Month, Status);
ReportViewModels model = new ReportViewModels
{
DataSetName = "PMAuditDataSet",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\PMAuditSummary.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult PreventiveSummary(int Year, int Month, int PlantId, int ScheduleType)
{
var ReportDataSource = this._reportService.GetSummaryReportData(Year, Month, PlantId, ScheduleType);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\PreventiveSummaryReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult PRSummaryReport(int year, int month)
{
var ReportDataSource = this._reportService.GetPRReportData(year, month);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\PRSummaryReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult ConsolidateReport(int Year)
{
var ReportDataSource = this._reportService.GetConsolidatedIndentData(Year);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\ConsolidateReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult IndentBudget(int PlantId, int Year)
{
var ReportDataSource = this._reportService.GetIssuedIndentDetail(PlantId, Year);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\IndentBudgetReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult QualityObjectiveYearlySummary(int Year)
{
var ReportDataSource = this._reportService.GetQOSReportData(Year);
ReportViewModels model = new ReportViewModels
{
DataSetName = "QualityObjectiveDataSet",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\QualityObjectiveYearlySummary.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult RepeatedMajorReport(int Year, int Month, string Id)
{
var ReportDataSource = this._reportService.GetRepeatedMajorReportData(Year, Month, Id);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\RepeatedMajorReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult ShutdownMonthlySummary(int plantId, int year, int month)
{
var ReportDataSource = this._reportService.GetShutdownSummaryReportData(plantId, year, month);
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\ShutdownMonthlySummary.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult InvoiceDetails(int Id)
{
var ReportDataSource = this._studentprogramInvoiceService.getInvoiceDetails(Id);
var schoolInfo = this._studentprogramInvoiceService.InstitutionDetails();
var schoolName = schoolInfo.Where(w => w.Name == "InstitutionName").Select(s => s.Value).FirstOrDefault();
var schooladdress = schoolInfo.Where(w => w.Name == "Address").Select(s => s.Value).FirstOrDefault();
var schoolcity = schoolInfo.Where(w => w.Name == "City").Select(s => s.Value).FirstOrDefault();
var schoolstate = schoolInfo.Where(w => w.Name == "State").Select(s => s.Value).FirstOrDefault();
var schoolPincode = schoolInfo.Where(w => w.Name == "Pincode").Select(s => s.Value).FirstOrDefault();
var schoolPhone = schoolInfo.Where(w => w.Name == "Phone").Select(s => s.Value).FirstOrDefault();
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportParameters = new { InstitutionName = schoolName, InstitutionAddress = schooladdress, InstitutionCity = schoolcity, InstitutionState = schoolstate, InstitutionPincode = schoolPincode, InstitutionPhone = schoolPhone },
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Invoice.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public ActionResult TimeSheetSummary(int id)
{
var concernId = Convert.ToInt32(Session["ConcernId"]);
var userId = Convert.ToInt32(Session["UserId"]);
var userName = Convert.ToString(Session["UserName"]);
if (userId > 0 && concernId > 0)
{
//var today = DateTime.Now.ToString("yyyy-MM-dd");
//var today = DateTime.Now.ToString("yyyy-MM-dd");
var sheet = _report.TimeSheetSummary(userName, userId, id, "en-US");
ReportViewModels viewModels = new ReportViewModels
{
ResponseTimeSheets = sheet
};
var report = new PartialViewAsPdf("TimeSheetSummary", viewModels);
return(report);
}
return(RedirectToAction("LogIn", "GlobalData", new { Area = "Global" }));
}
public ActionResult MaintenanceRequestReport(int Year, int Month)
{
var ReportDataSource = this._reportService.GetMaintenanceRequestData(Year, Month);
foreach (var item in ReportDataSource)
{
if (item.WorkEndDate == null)
{
continue;
}
var startDateTime = item.RequestDate.Add(item.RequestTime);
var endDateTime = item.WorkEndDate.Value.Add(item.WorkEndTime.Value);
var dateDiff = (endDateTime - startDateTime);
item.TimeSpent = string.Format("{0} Days {1} Hours {2} Mins", (int)dateDiff.TotalDays, dateDiff.Hours, dateDiff.Minutes);
}
ReportViewModels model = new ReportViewModels
{
DataSetName = "DataSet1",
ReportDataSource = ReportDataSource,
ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\MaintenanceRequestReport.rdlc"
};
return(PartialView("_RdlcReportViewer", model));
}
public CashCutController()
{
_cashCutVM = new CashCutViewModels();
_context = new adMarissa_Bios_no_le_pEntities();
_reportVM = new ReportViewModels();
}
public ActionResult OPD(ReportViewModels.OPDViewModel model)
{
model.EndDateTime = model.EndDateTime.AddDays(1);
model.Search();
return View(model);
}
public ActionResult CAO(ReportViewModels.MiscReports model)
{
model.EndDateTime = DateTime.Today.AddDays(1);
model.CAO();
return View(model);
}
