Esempio n. 1
0
        public ActionResult ShowReport(DAL.Models.DAL_M_VendorDD vendordetails)
        {
            LogWriter logw = new LogWriter("ValuesController entry");

            string uploadPath = System.Configuration.ConfigurationManager.AppSettings["Uploadpath"];  //  here is the path where  vendorreport file will be saved
            //string uploadFileName = Path.Combine(Server.MapPath("~/" + uploadPath + "/ "), vendordetails.VendorReportFileName);
            string       uploadFileName = System.Web.HttpContext.Current.Server.MapPath("~/" + uploadPath + "/" + vendordetails.VendorReportFileName);
            ReportViewer viewer         = new ReportViewer();

            viewer.ProcessingMode         = ProcessingMode.Local;
            viewer.SizeToReportContent    = true;
            viewer.SizeToReportContent    = true;
            viewer.AsyncRendering         = true;
            viewer.LocalReport.ReportPath = "VendorAuthorizationForm.rdlc";
            DataTable        vdt = createVendorDataTable(vendordetails);
            ReportDataSource rds = new ReportDataSource("VendorDataSet", vdt);
            // location ds
            DataTable        ldt = createLocationDataTable(vendordetails);
            ReportDataSource lds = new ReportDataSource("VendorDataLocDataSet", ldt);

            viewer.LocalReport.DataSources.Clear();
            viewer.LocalReport.DataSources.Add(rds);
            viewer.LocalReport.DataSources.Add(lds);
            string retFileName = PDFExport(viewer.LocalReport, uploadFileName, vendordetails.VendorReportFileName);

            return(Json(retFileName));
        }
Esempio n. 2
0
        public DataTable createLocationDataTable(DAL.Models.DAL_M_VendorDD vendordetails)
        {
            if (vendordetails.LocationAddressDescList.Count <= 0)
            {
                return(null);
            }
            DataTable dt = new DataTable();

            dt.Clear();
            dt.Columns.Add("LocationAddress");

            int cnt = 1;

            foreach (string locadd in vendordetails.LocationAddressDescList)
            {
                if (locadd != null && locadd != string.Empty)
                {
                    DataRow dr = dt.NewRow();
                    dr["LocationAddress"] = cnt.ToString() + ". " + locadd;
                    cnt++;
                    dt.Rows.Add(dr);
                }
            }

            return(dt);
        }
Esempio n. 3
0
        public DataTable createVendorDataTable(DAL.Models.DAL_M_VendorDD vendordetails)
        {
            DataTable dt = new DataTable();

            dt.Clear();
            dt.Columns.Add("VendorNumber");
            dt.Columns.Add("VendorName");
            dt.Columns.Add("ssn");
            dt.Columns.Add("DDNotifiEmail");
            dt.Columns.Add("AccountType");
            dt.Columns.Add("BankAccountNumber");
            dt.Columns.Add("BankRoutingNo");
            dt.Columns.Add("FinancialIns");
            dt.Columns.Add("Signeremail");
            dt.Columns.Add("Signername");
            dt.Columns.Add("Signerphone");
            dt.Columns.Add("Signertitle");
            dt.Columns.Add("VendorAttachmentFileName");
            dt.Columns.Add("SubmittedDate");
            dt.Columns.Add("TotalAttachment");
            dt.Columns.Add("ConfirmationNumber");
            DataRow dr = dt.NewRow();

            dr["VendorNumber"] = vendordetails.Vendorname;
            dr["VendorName"]   = vendordetails.Payeename;

            dr["ssn"]           = getMaskedSSN(vendordetails.Ssn);
            dr["DDNotifiEmail"] = vendordetails.DDNotifyEmail;
            if (vendordetails.AccountType == 2)  //  1 changes 2
            {
                dr["AccountType"] = "Checking";
            }
            else if (vendordetails.AccountType == 1)
            {
                dr["AccountType"] = "Saving";
            }
            else
            {
                dr["AccountType"] = "Error";
            }
            dr["BankAccountNumber"]        = vendordetails.BankAccountNumber;
            dr["BankRoutingNo"]            = vendordetails.BankRoutingNo;
            dr["FinancialIns"]             = vendordetails.FinancialIns;
            dr["Signeremail"]              = vendordetails.Signeremail;
            dr["Signername"]               = vendordetails.Signername;
            dr["Signerphone"]              = vendordetails.Signerphone;
            dr["Signertitle"]              = vendordetails.Signertitle;
            dr["VendorAttachmentFileName"] = vendordetails.VendorAttachmentFileName;

            dr["TotalAttachment"]    = "Total: 1";
            dr["SubmittedDate"]      = "SubmittedDate: " + vendordetails.SubmitDateTime.ToString("g", System.Globalization.CultureInfo.CreateSpecificCulture("en-us"));
            dr["ConfirmationNumber"] = vendordetails.Confirmation;
            dt.Rows.Add(dr);
            return(dt);
        }