Exemple #1
0
        //Get Data Queue Statistics report of  API Usages
        public ActionResult OIAPIUsageStatisticsGrid(bool IsDownload = false)
        {
            OIDashboardFacade fac = new OIDashboardFacade(this.CurrentClient.ApplicationDBConnectionString);
            DataSet           ds  = fac.GetDashboardQueueCount();
            DataTable         dt  = new DataTable();

            if (ds != null && ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
                if (dt != null && dt.Rows != null && dt.Rows.Count != 0)
                {
                    if (dt.Rows[0]["Importdate"] == DBNull.Value)
                    {
                        dt.Rows[0]["Importdate"] = DateTime.Now;
                    }
                    DataRow firstRow = (dt.Rows[0] as DataRow).Copy();
                    dt.Rows.Add(firstRow.ItemArray);
                    dt.Rows.RemoveAt(0);
                }
            }
            if (dt != null && IsDownload)
            {
                string fileName  = "OI Data Queue Statistics_" + DateTime.Now.Ticks.ToString() + ".xlsx";
                string SheetName = "OI Data Queue Statistics";
                byte[] response  = CommonExportMethods.ExportExcelFile(dt, fileName, SheetName);
                return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
            }
            else
            {
                ViewBag.DownloadErrormessage = CommonMessagesLang.msgCommanErrorMessage;
            }
            return(View("~/Views/OI/OIHome/OIAPIUsageStatisticsGrid.cshtml", dt));
        }
        public ActionResult DownloadScreeningResult(string name)
        {
            List <ScreenResponseEntity> lstScreenRespinseData = JsonConvert.DeserializeObject <List <ScreenResponseEntity> >(SessionHelper.ScreenResultData);
            DataTable dt       = CommonMethod.ToDataTable <ScreenResponseEntity>(lstScreenRespinseData);
            string    filename = name + " - ScreeningDetails.xlsx";

            byte[] response = CommonExportMethods.ExportExcelFile(dt, filename, "ScreeningDetails");
            return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename));
        }
        public ActionResult ExportUnprocessedRecords()
        {
            int totalCount = 0;
            UnprocessedInputFacade        fac             = new UnprocessedInputFacade(this.CurrentClient.ApplicationDBConnectionString);
            List <UnprocessedInputEntity> lstUnprocesseds = fac.GetUnprocessedInputRecords("", 50, -1, out totalCount);
            DataTable dtUnprocesseds = CommonMethod.ToDataTable(lstUnprocesseds);

            string fileName  = "Input Records_" + DateTime.Now.Ticks.ToString() + ".xlsx";
            string SheetName = "Input Records";

            byte[] response = CommonExportMethods.ExportExcelFile(dtUnprocesseds, fileName, SheetName);
            return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
        }
Exemple #4
0
        public ActionResult ExportExcel()
        {
            long          searchResultId = Convert.ToInt64(Session["Id"]);
            CompanyFacade fac            = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName);
            var           data           = fac.ExportBuildResult(searchResultId);

            if (searchResultId <= 0)
            {
                data = new System.Data.DataTable();
            }
            string fileName  = "BuildList_" + DateTime.Now.Ticks.ToString() + ".xlsx";
            string SheetName = "BuildList";

            byte[] response = CommonExportMethods.ExportExcelFile(data, fileName, SheetName);
            return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
        }
Exemple #5
0
        public ActionResult CacheDataPopup(string ClientCode, string CountryISOAlpha2Code)
        {
            List <DownloadCacheDataModel> model = new List <DownloadCacheDataModel>();

            if (ModelState.IsValid)
            {
                try
                {
                    string APIFamily = string.Empty;

                    Clients api = new Clients();
                    // API Call for Download Cache Data
                    model = api.DownloadCacheData(ClientCode, CountryISOAlpha2Code, APIFamily);
                    if (model != null)
                    {
                        List <DownloadCacheDataModel> lstResult = new List <DownloadCacheDataModel>();
                        lstResult = model;
                        DataTable data = ToDataTable(lstResult);
                        if (lstResult == null)
                        {
                            data = new DataTable();
                        }
                        string fileName  = "CacheData" + DateTime.Now.Ticks.ToString() + ".xlsx";
                        string SheetName = "CacheData";
                        // Exporting the cache data in an excel format
                        byte[] response = CommonExportMethods.ExportExcelFile(data, fileName, SheetName);
                        return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
                    }
                    else
                    {
                        Session["Message"] = ExportLang.msgNoRecordFound;
                        return(RedirectToAction("Index", "DNBFeature"));
                    }
                }
                catch (Exception)
                {
                    Session["Message"] = CommonMessagesLang.msgCommanErrorMessage;
                    return(RedirectToAction("Index", "DNBFeature"));
                }
            }
            Session["Message"] = CommonMessagesLang.msgCommanInsertMessage;
            return(RedirectToAction("Index", "DNBFeature"));
        }
Exemple #6
0
        public ActionResult ExportToExcel()
        {
            List <Result> lstResult = new List <Result>();

            lstResult = JsonConvert.DeserializeObject <List <Result> >(Session["OIExportToExcel"].ToString());

            if (lstResult == null)
            {
                int?pagevalue = null;
                int pageSize  = pagevalue.HasValue ? pagevalue.Value : 30;
                OIBuildListSearchModelEntity model = new OIBuildListSearchModelEntity();
                string[] hostParts = new System.Uri(Request.Url.AbsoluteUri).Authority.Split('.');
                string   SubDomain = hostParts[0];
                model.request_fields = JsonConvert.DeserializeObject <RequestFields>(Session["OIBuildDataRequestFields"].ToString());
                Utility.OI.OIBuildList       api         = new Utility.OI.OIBuildList();
                OIBuildListSearchModelEntity objResponse = api.OIBuildAList(model, pageSize, SubDomain);
                Session["OIBuildDataResults"] = JsonConvert.SerializeObject(objResponse.results);
                lstResult = JsonConvert.DeserializeObject <List <Result> >(Session["OIBuildDataResults"].ToString());
            }
            else
            {
                lstResult = JsonConvert.DeserializeObject <List <Result> >(Session["OIExportToExcel"].ToString());
            }

            DataTable data = CommonMethod.ToDataTable(lstResult);

            if (lstResult == null)
            {
                data = new DataTable();
            }
            string fileName  = "OIBuildList_" + DateTime.Now.Ticks.ToString() + ".xlsx";
            string SheetName = "OIBuildList";

            byte[] response = CommonExportMethods.ExportExcelFile(data, fileName, SheetName);
            return(File(response, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
        }