public ActionResult OrganizationInfo(string OrganizationID)
{
var data = new DW_DC_Organization();
data = DW_DC_Organization.GetListOrganizationForCSByOrgID(OrganizationID);
return(Json(data));
}
public ActionResult Read_OrganizationForTeleSale([DataSourceRequest] DataSourceRequest request)
{
var data = new List <DW_DC_Organization>();
//if (request.Filters.Any())
//{
//var where = KendoApplyFilter.ApplyFilter(request.Filters[0], "");
data = DW_DC_Organization.GetListOrganizationForTeleSale().ToList();
//}
//else
//{
// data = DW_DC_Organization.GetListOrganizationForTeleSale().ToList();
//}
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult Export([DataSourceRequest] DataSourceRequest request)
{
if (asset.Export)
{
var data = DW_DC_Organization.GetListOrganizationForTeleSale().ToList();
IEnumerable datas = data.ToDataSourceResult(request).Data;
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_OrganizationForTeleSale.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["DC_OrganizationForTeleSale"];
int rowData = 1;
foreach (DW_DC_Organization item in datas)
{
int i = 1;
rowData++;
dataSheet.Cells[rowData, i++].Value = item.OrganizationID;
dataSheet.Cells[rowData, i++].Value = item.LongName;
dataSheet.Cells[rowData, i++].Value = item.Address;
if (string.IsNullOrEmpty(item.CheckAllowServices))
{
dataSheet.Cells[rowData, i++].Value = "";
}
else
{
if (item.CheckAllowServices == "1")
{
dataSheet.Cells[rowData, i++].Value = "Airtime";
}
else if (item.CheckAllowServices == "2")
{
dataSheet.Cells[rowData, i++].Value = "Airtime, Cashdvance, Physical goods, Services";
}
else
{
dataSheet.Cells[rowData, i++].Value = "Airtime, Physical goods, Services";
}
}
dataSheet.Cells[rowData, i++].Value = item.SalesPriority;
if (!string.IsNullOrEmpty(item.CollectionType))
{
var data1 = Deca_Code_Master.GetDeca_Code_Masters("[CodeID] = '" + item.CollectionType + "'", "").FirstOrDefault();
dataSheet.Cells[rowData, i++].Value = data1.Description;
}
else
{
dataSheet.Cells[rowData, i++].Value = "";
}
dataSheet.Cells[rowData, i++].Value = item.TeleSaleNote;
dataSheet.Cells[rowData, i++].Value = item.KeyPerson;
dataSheet.Cells[rowData, i++].Value = item.OnsiteInfo;
dataSheet.Cells[rowData, i++].Value = item.DeliveryNote;
dataSheet.Cells[rowData, i++].Value = item.CreditLimitRules;
dataSheet.Cells[rowData, i++].Value = item.SettlementDate;
dataSheet.Cells[rowData, i++].Value = item.DeliveryNote;
dataSheet.Cells[rowData, i++].Value = item.Note;
dataSheet.Cells[rowData, i++].Value = item.RegionalBD;
dataSheet.Cells[rowData, i++].Value = item.DueDate;
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
string fileName = "DC_OrganizationForTeleSale_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
else
{
ModelState.AddModelError("", "You don't have permission to export data");
return(File("", //The binary data of the XLS file
"application/vnd.ms-excel", //MIME type of Excel files
"DC_TelesaleAgent" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls")); //Suggested file name in the "Save as" dialog which will be displayed to the end user
}
}
