I have multiple list data, and i want to export them. My code is working fine. All excel file save into database but issue is, only one dialog box displaying in front-end.
As i have multiple rows of data
For example i have 7 rows of data and i want to display 7 times save download dialog box
I want multiple dialog box should open in front-end
for (int i = 0; i < jobNumList.Count; i++)
{
var ii = jobNumList[i];
string filename = ii;
string folderpath = HttpContext.Server.MapPath("/ExcelFiles/");
string filepath = Path.Combine(folderpath, filename);
if (db.tblSoftGoodsDatas.Any(z=>z.BATCH==ii))
{
var catagory = db.tblSoftGoodsDatas.Where(z => z.BATCH == ii).FirstOrDefault().CATEGORY;
var tbl = db.tblSoftGoodsDatas.Where(z => z.BATCH == ii).ToList();
switch (catagory)
{
case "QFLB11":
string htmlresult = RenderRazorViewToString(ControllerContext, "~/Views/Home/QFLB11.cshtml", tbl);
byte[] excelbytes = Encoding.ASCII.GetBytes(htmlresult);
MemoryStream memStream = new MemoryStream();
memStream.Write(excelbytes, 0, excelbytes.Length);
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
Response.ContentType = "application/vnd.ms-excel";
Response.Write(htmlresult);
Response.End();
Response.Flush();
break;
}
}
}