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");
}
