public ActionResult MappingLocation_Read([DataSourceRequest] DataSourceRequest request)
{
var data = new List <DC_Location_MappingLocation>();
data = DC_Location_MappingLocation.GetAllDC_Location_Regions();
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult ListShippingCityAll_Read([DataSourceRequest] DataSourceRequest request, string RegionID)
{
var data = new List <DC_Location_MappingLocation>();
data = DC_Location_MappingLocation.GetAllDC_Location_Mapping_City(RegionID).ToList();
return(Json(data.ToDataSourceResult(request)));
}
public ActionResult getInfoByRegion(string RegionID)
{
var data = new DC_Location_MappingLocation();
data = DC_Location_MappingLocation.GetAllDC_Location_Regions().Where(s => s.RegionID == RegionID).FirstOrDefault();
return(Json(data));
//return Json(data.ToDataSourceResult(request));
}
public FileResult ExportExcel([DataSourceRequest] DataSourceRequest request)
{
if (asset.Export)
{
var list = DC_Location_MappingLocation.GetAllDC_Location_Mappinged_City().ToList();
//using (ExcelPackage excelPkg = new ExcelPackage())
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_Location_MappingLocation.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
//data sheet
ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["DC_Location_MappingLocation"];
IEnumerable listData = list.ToDataSourceResult(request).Data;
int rowData = 1;
foreach (DC_Location_MappingLocation data in listData)
{
int i = 1;
rowData++;
dataSheet.Cells[rowData, i++].Value = data.CityID;
dataSheet.Cells[rowData, i++].Value = data.CityName;
dataSheet.Cells[rowData, i++].Value = data.RegionID + " - " + data.RegionName;
}
//data sheet
var region = DC_Location_Region.GetAllDC_Location_Regions();
ExcelWorksheet dataSheetList = excelPkg.Workbook.Worksheets["List"];
IEnumerable listDataRegion = region.ToDataSourceResult(request).Data;
int rowDataRegion = 1;
foreach (DC_Location_Region data in listDataRegion)
{
int i = 1;
rowDataRegion++;
dataSheetList.Cells[rowDataRegion, i++].Value = data.RegionID + " - " + data.RegionName;
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
string fileName = "DC_Location_MappingLocation_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
else
{
string fileName = "DC_Location_MappingLocation_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
return(File("", contentType, fileName));
}
}
public ActionResult Mapping(string id)
{
var hOld = DC_Location_MappingLocation.GetAllDC_Location_Regions().Where(s => s.RegionID == id).FirstOrDefault();
if (hOld != null)
{
ViewBag.hOld = id;
ViewBag.Region = DC_Location_MappingLocation.GetAllDC_Location_Regions();
return(View(hOld));
}
else
{
return(RedirectToAction("Index"));
}
}
public FileResult ExportExcelAllMappinged([DataSourceRequest] DataSourceRequest request)
{
if (asset.Export)
{
var ShippingCity = DC_Location_MappingLocation.GetAllListCityMappingFrom_ShippingCity().ToList();
var PortalCity = DC_Location_MappingLocation.GetAllListCityMappingFrom_PortalCity().ToList();
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_Location_MappingRegionCity.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
//ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["DC_Location_Mapping_City"];
//IEnumerable listData = ShippingCity.ToDataSourceResult(request).Data;
//int rowData = 1;
//foreach (DC_Location_MappingLocation data in listData)
//{
// int i = 1;
// rowData++;
// dataSheet.Cells[rowData, i++].Value = data.RegionName;
// dataSheet.Cells[rowData, i++].Value = data.ShippingCity;
// dataSheet.Cells[rowData, i++].Value = "MCA Shipping City";
//}
ExcelWorksheet dataSheetPortal = excelPkg.Workbook.Worksheets["DC_Location_Mapping_City"];
IEnumerable listPortalCity = PortalCity.ToDataSourceResult(request).Data;
int rowDataMCA = 1;
foreach (DC_Location_MappingLocation data in listPortalCity)
{
int i = 1;
rowDataMCA++;
//dataSheetPortal.Cells[rowDataMCA, i++].Value = data.RegionName;
dataSheetPortal.Cells[rowDataMCA, i++].Value = data.RegionName;
dataSheetPortal.Cells[rowDataMCA, i++].Value = data.CityName;
//dataSheetPortal.Cells[rowDataMCA, i++].Value = "Portal City";
}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
string fileName = "DC_Location_MappingRegionCity_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
else
{
string fileName = "DC_Location_MappingRegionCity_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
return(File("", contentType, fileName));
}
}
public FileResult ExportExcelMapping([DataSourceRequest] DataSourceRequest request, string RegionID)
{
if (asset.Export)
{
var Alias = DC_Location_MappingLocation.GetAllDC_Location_Mapping_City(RegionID).ToList();
var portal = DC_Location_MappingLocation.GetAllDC_Location_Portal_City(RegionID).ToList();
FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_Location_Mapping_City.xlsx"));
var excelPkg = new ExcelPackage(fileInfo);
ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["MappingCity"];
IEnumerable listData = Alias.ToDataSourceResult(request).Data;
IEnumerable listData_portal = portal.ToDataSourceResult(request).Data;
int rowData = 1;
int rowNumber = 1;
int index_tmp = 0;
var rowtemp = 1;
foreach (DC_Location_MappingLocation data in listData)
{
int i = 1;
rowData++;
dataSheet.Cells[rowData, i++].Value = data.ShippingCity;
dataSheet.Cells[rowData, i++].Value = " MCA Shipping City";
rowtemp = rowData;
}
//foreach (DC_Location_MappingLocation data_portal in listData_portal)
//{
// int i = 1;
// rowtemp++;
// dataSheet.Cells[rowtemp, i++].Value = data_portal.CityName;
// dataSheet.Cells[rowtemp, i++].Value = "Portal City";
//}
MemoryStream output = new MemoryStream();
excelPkg.SaveAs(output);
string fileName = "DC_Location_Mapping_City_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
output.Position = 0;
return(File(output.ToArray(), contentType, fileName));
}
else
{
string fileName = "DC_Location_Mapping_City_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
return(File("", contentType, fileName));
}
}
