public void AddRptCurrentWorkloadReportParameters() { List <CurrentWorkloadReportParameter> _rptCurrentWorkloadReportParameters = new List <CurrentWorkloadReportParameter>(); CurrentWorkloadReportParameter _CurrentWorkloadParameters = new CurrentWorkloadReportParameter(); for (int i = 0; i < 4; i++) { _CurrentWorkloadParameters.ClientID = i; _CurrentWorkloadParameters.StatusID = i + 1; _rptCurrentWorkloadReportParameters.Add(_CurrentWorkloadParameters); } _CurrentWorkloadRepository.AddRptCurrentWorkloadReportParameters(_rptCurrentWorkloadReportParameters); }
public JsonResult GetResultReport(string startDate, string endDate, string ClientId, string StatusId) { try { //adding currentworkload report name to database CurrentWorkloadReport _CurrentWorkloadReport = new CurrentWorkloadReport(); _CurrentWorkloadReport.CurrentWorkloadReportName = GlobalConst.SSRSReportName.RptCurrentWorkload + DateTime.Now.ToString("ddMMyyyyss") + GlobalConst.Extension.xlsx; int _currentworkReportID = _iCurrentWorkloadService.AddCurrentWorkloadReport(Mapper.Map <MMC.MMCService.CurrentWorkloadService.CurrentWorkloadReport>(_CurrentWorkloadReport)); List <CurrentWorkloadReportParameter> _CurrentWorkloadReportParameterList = new List <CurrentWorkloadReportParameter>(); int[] clientIDArray = new int[0]; int[] statusIDArray = new int[0]; if (ClientId != "") { clientIDArray = Array.ConvertAll(ClientId.Split(','), int.Parse); } if (StatusId != "") { statusIDArray = Array.ConvertAll(StatusId.Split(','), int.Parse); } int loopCheck = (clientIDArray.Length > statusIDArray.Length) ? clientIDArray.Length : statusIDArray.Length; for (int i = 0; i < loopCheck; i++) { CurrentWorkloadReportParameter currentworkloadReportParameter = new CurrentWorkloadReportParameter(); if (i < clientIDArray.Length) { currentworkloadReportParameter.ClientID = clientIDArray[i]; } if (i < statusIDArray.Length) { currentworkloadReportParameter.StatusID = statusIDArray[i]; } currentworkloadReportParameter.CurrentWorkloadReportID = _currentworkReportID; _CurrentWorkloadReportParameterList.Add(currentworkloadReportParameter); } //adding Currentworkload report parameters _iCurrentWorkloadService.AddRptCurrentWorkloadReportParameters(Mapper.Map <List <MMC.MMCService.CurrentWorkloadService.CurrentWorkloadReportParameter> >(_CurrentWorkloadReportParameterList)); string reportURL = string.Format(ConfigurationManager.AppSettings[GlobalConst.SSRSReportName.RptCurrentWorkload], _currentworkReportID, startDate, endDate, GlobalConst.Extension.EXCEL); string storagePath = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings[GlobalConst.VirtualDirectoryPath.VirtualPath].ToString()); string savePath = _storageService.getCurrentWokloadReportStorage(storagePath, GlobalConst.FolderName.CurrentWorkloadReport) + GlobalConst.ConstantChar.DoubleForwardSlash + _CurrentWorkloadReport.CurrentWorkloadReportName; using (WebClient client = new WebClient()) { client.Credentials = CredentialCache.DefaultNetworkCredentials; client.DownloadFile(reportURL, savePath); client.Dispose(); } string ReportLink = GlobalConst.ConstantChar.DoubleForwardSlash + GlobalConst.ConstantChar.Storage + GlobalConst.ConstantChar.DoubleForwardSlash + GlobalConst.FolderName.CurrentWorkloadReport + GlobalConst.ConstantChar.DoubleBackwardSlash + _CurrentWorkloadReport.CurrentWorkloadReportName; return(Json(ReportLink)); } catch (Exception e) { return(Json(e.Message)); } }