public void ExportToCSV(FormCollection collection) { List <SelectListItem> lstheader = new List <SelectListItem>(); lstheader.Add(new SelectListItem() { Text = "Order Date", Value = "TransactionDate" }); lstheader.Add(new SelectListItem() { Text = "Last Transaction Details", Value = "TransactionDetail" }); lstheader.Add(new SelectListItem() { Text = "Type", Value = "TransactionMode" }); lstheader.Add(new SelectListItem() { Text = "Payment-Amount", Value = "PaymentAmount" }); lstheader.Add(new SelectListItem() { Text = "Payment Mode", Value = "PaymentMode" }); lstheader.Add(new SelectListItem() { Text = "Credit", Value = "CreditAmount" }); WBHelper.GetCSVFile <AccountStatement>(GetUserTransData(collection), lstheader, "Statement"); }
public void ExportDataToCSV(string ResellerName, string Email, RecordStatus?eRecordStatus, DateTime dtStartDate, DateTime dtEndDate, decimal MinPrice, decimal MaxPrice) { var resellers = _service.GetResellerData(Site.ID, ResellerName, Email, eRecordStatus, dtStartDate, dtEndDate, MinPrice, MaxPrice).OrderBy(ord => ord.TotalPurchase).ThenBy(t => t.CompanyName).ThenBy(n => n.FirstName); List <SelectListItem> lstheader = new List <SelectListItem>(); lstheader.Add(new SelectListItem() { Text = "First Name", Value = "FirstName" }); lstheader.Add(new SelectListItem() { Text = "Last Name", Value = "LastName" }); lstheader.Add(new SelectListItem() { Text = "Contract Name", Value = "ContractName" }); lstheader.Add(new SelectListItem() { Text = "Reseller Since", Value = "RegisterDate" }); lstheader.Add(new SelectListItem() { Text = "Total Purchase", Value = "TotalPurchase" }); lstheader.Add(new SelectListItem() { Text = "IsActive", Value = "RecordStatusID" }); WBHelper.GetCSVFile <UserExt>(resellers.ToList(), lstheader, "ResellerList"); }
public void ExportDataToCSV(string Name, string Email) { var cutomers = _service.GetCustomerList(Site.ID, Name, Email).OrderBy(ord => ord.TotalPurchase).ThenBy(t => t.CompanyName).ThenBy(n => n.FirstName); List <SelectListItem> lstheader = new List <SelectListItem>(); lstheader.Add(new SelectListItem() { Text = "First Name", Value = "FirstName" }); lstheader.Add(new SelectListItem() { Text = "Last Name", Value = "LastName" }); lstheader.Add(new SelectListItem() { Text = "Reseller Since", Value = "RegisterDate" }); lstheader.Add(new SelectListItem() { Text = "Total Purchase", Value = "TotalPurchase" }); lstheader.Add(new SelectListItem() { Text = "IsActive", Value = "RecordStatusID" }); WBHelper.GetCSVFile <UserExt>(cutomers.ToList(), lstheader, "CustomerList"); }
private void ExportDataToCSV(FormCollection collection) { List <OrderDetail> lstorderdetail = getSearchModel(collection).ToList(); List <string> lstData = new List <string>(); lstData.Add("Order Date,OrderID,Product Name,InvoiceID,Domain Name,Order Status,Price,"); foreach (OrderDetail ord in lstorderdetail) { lstData.Add(ord.AuditDetails.DateCreated.ToShortDateString() + "," + ord.ExternalOrderID + "," + ord.ProductName + "," + InvoicePrefix + ord.OrderID + "," + (string.IsNullOrEmpty(ord.CertificateRequest.DomainName) ? "-" : ord.CertificateRequest.DomainName) + "," + ord.OrderStatus + "," + ord.Price.ToString("c").Replace(",", string.Empty)); } WBHelper.GetCSVFile(lstData, "OrderList"); }
public void ExportDataToCSV(OrderStatus?eOrderStatus, DateTime dtStartDate, DateTime dtEndDate) { var orderdetail = GetDateWiseOrders(eOrderStatus, dtStartDate, dtEndDate).ToList(); List <string> lstData = new List <string>(); lstData.Add("Order Date,OrderID,Product Name,InvoiceID,Domain Name,Order Status,Price,"); foreach (OrderDetail ord in orderdetail) { lstData.Add(ord.AuditDetails.DateCreated.ToShortDateString() + "," + ord.ExternalOrderID + "," + ord.ProductName + "," + InvoicePrefix + ord.OrderID + "," + (string.IsNullOrEmpty(ord.CertificateRequest.DomainName) ? "-" : ord.CertificateRequest.DomainName) + "," + ord.OrderStatus + "," + ord.Price.ToString("c").Replace(",", string.Empty)); } WBHelper.GetCSVFile(lstData, "OrderList"); }
public void ExportDataToCSV(int?UserID, OrderStatus?eOrderStatus, DateTime dtStartDate, DateTime dtEndDate) { var orderdetail = (_repository.Find(od => od.Order.SiteID == Site.ID && od.Order.UserID == (UserID == null ? od.Order.UserID : UserID) && od.OrderStatusID == (eOrderStatus != null ? (int?)eOrderStatus : od.OrderStatusID) && (System.Data.Entity.DbFunctions.DiffDays(dtStartDate, od.AuditDetails.DateCreated) >= 0 && System.Data.Entity.DbFunctions.DiffDays(od.AuditDetails.DateCreated, dtEndDate) >= 0)) .EagerLoad(ut => ut.AuditDetails, ut => ut.CertificateRequest).OrderByDescending(ord => ord.AuditDetails.DateCreated)).ToList(); List <string> lstData = new List <string>(); lstData.Add("Order Date,OrderID,Product Name,InvoiceID,Domain Name,Order Status,Price,"); foreach (OrderDetail ord in orderdetail) { lstData.Add(ord.AuditDetails.DateCreated.ToShortDateString() + "," + ord.ExternalOrderID + "," + ord.ProductName + "," + InvoicePrefix + ord.OrderID + "," + (string.IsNullOrEmpty(ord.CertificateRequest.DomainName) ? "-" : ord.CertificateRequest.DomainName) + "," + ord.OrderStatus + "," + ord.Price.ToString("c").Replace(",", string.Empty)); } WBHelper.GetCSVFile(lstData, "OrderList"); }