public JsonResult Data([Bind(Include = "PartNr,DateFrom,DateTo,Type,Top")] DashboardSearchModel searchModel)
{
IDashboardService ds = new DashboardService(Properties.Settings.Default.db);
Dictionary <string, List <DashboardItem> > data = new Dictionary <string, List <DashboardItem> >();
// List<DashboardItem> items = new List<DashboardItem>();
switch (searchModel.Type)
{
case 100:
data = ds.GetPartStockDash(searchModel);
break;
case 200:
data = ds.GetPartCompleteRateDash(searchModel);
break;
case 300:
searchModel.DateFrom = DateTime.Now.Date.AddDays(-8);
searchModel.DateTo = DateTime.Now.Date.AddDays(-1);
data = ds.GetPartTopRateDash(searchModel);
break;
default:
break;
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public static async Task <IEnumerable <EventSummaryModel> > GetEventSummary(DashboardSearchModel searchModel)
{
List <EventSummaryModel> modelResult = new List <EventSummaryModel>();
EventSummaryModel report = null;
if (searchModel != null)
{
object[] param = new object[] { searchModel.OrganizationUrl, searchModel.StartDate, searchModel.EndDate };
var result = await ColligoO365RMOManager <DashboardChartData> .ExecuteSqlQueryAsync(Procedure.UspReportChartData, param);
//converT data to framework model
if (result != null && result.Any())
{
Type source = typeof(DashboardChartData);
Type destination = typeof(EventSummaryModel);
foreach (var item in result)
{
report = new EventSummaryModel();
CopyHelper.Copy(source, item, destination, report);
modelResult.Add(report);
}
}
}
return(modelResult);
}
public IHttpActionResult GetDashboard(DashboardSearchModel model)
{
try
{
return(Ok());
}
catch (Exception ex)
{
return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)));
}
}
public async Task <IEnumerable <EventSummaryModel> > GetEventSummary(DashboardSearchModel searchModel)
{
try
{
return(await DashboardManager.GetEventSummary(searchModel));
}
catch (Exception ex)
{
_logger.Error("GetEventSummary-- error- ", ex);
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Problem in GetEventSummary"));
}
}
public string GetContentAuditSummary(string criteria)
{
ResetToken();
bool error = false;
DashboardSearchModel model = JsonHelper.ConvertToObject <DashboardSearchModel>(criteria);
List <ContentLogSummaryModel> apiResult = GetManyByPostFromAPI <DashboardSearchModel, ContentLogSummaryModel>(model, RMAdminAPI.GetContentAuditSummary, out error);
if (error || apiResult == null)
{
return("fail");
}
return(JsonHelper.ConvertToJson(apiResult));
}
public string SearchDashboardReport(string criteria)
{
ResetToken();
bool error = false;
DashboardSearchModel model = JsonHelper.ConvertToObject <DashboardSearchModel>(criteria);
EventReportModel apiResult = PostToApi <DashboardSearchModel, EventReportModel>(RMAdminAPI.SearchDashboardReport, model, out error);
if (error || apiResult == null)
{
return("fail");
}
return(JsonHelper.ConvertToJson(apiResult));
}
public ActionResult StockReport(int?page)
{
int pageIndex = PagingHelper.GetPageIndex(page);
DashboardSearchModel q = new DashboardSearchModel();
IStockSumRecordService sss = new StockSumRecordService(Properties.Settings.Default.db);
IPagedList <StockSumRecord> stockSumRecord = sss.SearchStockReport(q).ToPagedList(pageIndex, Properties.Settings.Default.pageSize);
ViewBag.Query = q;
return(View(stockSumRecord));
}
public ActionResult SearchStockReports([Bind(Include = "PartNr, DateFrom, DateTo")] DashboardSearchModel q)
{
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
IStockSumRecordService sss = new StockSumRecordService(Properties.Settings.Default.db);
IPagedList <StockSumRecord> stockSumRecord = sss.SearchStockReport(q).ToPagedList(pageIndex, Properties.Settings.Default.pageSize);
ViewBag.Query = q;
return(View("StockReport", stockSumRecord));
}
public ActionResult Dashboard()
{
decimal?USER_NO = Session["sess_USER_NO"] as decimal?;
DashboardSearchModel model = new DashboardSearchModel();
ObjectResult <DASHBOARD_REPORT_Result> dashboard = null;
model.Search_AM_User = null;
DateTime now = DateTime.Now;
DateTime FirstDayOfMonth = new DateTime(now.Year, now.Month, 1);
model.Search_Date_From = FirstDayOfMonth;
model.Search_Date_To = DateTime.Now;
if (!string.IsNullOrEmpty(Request.QueryString["Search"]))
{
if (!string.IsNullOrEmpty(Request.QueryString["Search_AM_User"]))
{
model.Search_AM_User = decimal.Parse(Request.QueryString["Search_AM_User"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_From"]))
{
model.Search_Date_From = DateTime.Parse(Request.QueryString["Search_Date_From"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Date_To"]))
{
model.Search_Date_To = DateTime.Parse(Request.QueryString["Search_Date_To"]);
}
}
dashboard = db.DASHBOARD_REPORT(null, model.Search_AM_User, USER_NO,
model.Search_Date_From, model.Search_Date_To);
ViewBag.Search_Model = model;
return(View(dashboard));
}
public void ExportStockReport([Bind(Include = "PartNr, DateFrom, DateTo")] DashboardSearchModel q)
{
IStockSumRecordService sss = new StockSumRecordService(Properties.Settings.Default.db);
List <StockSumRecord> stockSumRecords = sss.SearchStockReport(q).ToList();
ViewBag.Query = q;
MemoryStream ms = new MemoryStream();
using (StreamWriter sw = new StreamWriter(ms, Encoding.UTF8))
{
List <string> head = new List <string> {
" No.", "PartNr", "Quantity", "Date"
};
sw.WriteLine(string.Join(Properties.Settings.Default.csvDelimiter, head));
for (var i = 0; i < stockSumRecords.Count; i++)
{
List <string> ii = new List <string>();
ii.Add((i + 1).ToString());
ii.Add(stockSumRecords[i].partNr);
ii.Add(stockSumRecords[i].quantity.ToString());
ii.Add(stockSumRecords[i].date.ToString());
sw.WriteLine(string.Join(Properties.Settings.Default.csvDelimiter, ii.ToArray()));
}
//sw.WriteLine(max);
}
var filename = "StockReport" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
var contenttype = "text/csv";
Response.Clear();
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = contenttype;
Response.AddHeader("content-disposition", "attachment;filename=" + filename);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite(ms.ToArray());
Response.End();
}
public static async Task <EventReportModel> GetEventReport(DashboardSearchModel searchModel)
{
EventReportModel report = null;
if (searchModel != null)
{
object[] param = new object[] { searchModel.OrganizationUrl, searchModel.StartDate, searchModel.EndDate, searchModel.Status };
var result = await ColligoO365RMOManager <DashboardResult> .ExecuteSqlQueryAsync(Procedure.UspReportADGAgent, param);
//converT data to framework model
if (result != null && result.Any())
{
Type source = typeof(DashboardResult);
Type destination = typeof(EventReportModel);
foreach (var item in result)
{
report = new EventReportModel();
CopyHelper.Copy(source, item, destination, report);
break;
}
}
}
return(report);
}
public static async Task <IEnumerable <ContentLogSummaryModel> > GetContentAuditSummary(DashboardSearchModel searchModel)
{
List <ContentLogSummaryModel> modelResult = new List <ContentLogSummaryModel>();
ContentLogSummaryModel report = null;
if (searchModel != null)
{
object[] param = new object[] { searchModel.OrganizationUrl, searchModel.SearchTerm, searchModel.PageNumber, searchModel.PageSize };
var result = await ColligoO365RMOManager <ContentAuditSummary> .ExecuteSqlQueryAsync(Procedure.UspReportContentAuditSummary, param);
//converT data to framework model
if (result != null && result.Any())
{
Type source = typeof(ContentAuditSummary);
Type destination = typeof(ContentLogSummaryModel);
foreach (var item in result)
{
report = new ContentLogSummaryModel();
CopyHelper.Copy(source, item, destination, report);
modelResult.Add(report);
}
}
}
return(modelResult);
}
