public ActionResult ExportBinderAllotment(string startDate, string endDate) { List <BinderAllotQuantity> listBinderAllotQuantity = new List <BinderAllotQuantity>(); try { StringBuilder strTableReport = new StringBuilder(); StringBuilder strReport = new StringBuilder(); strReport = new StringBuilder(); Int16 AccadYear = Convert.ToInt16(GlobalSettings.oUserData.AcademicYearId); DataTable dtbinderallot = objDbTrx.GetBinderAllotmentQtyView(Convert.ToDateTime(startDate + " 00:00:00.000"), Convert.ToDateTime(endDate + " 23:59:59.999"), AccadYear); if (dtbinderallot.Rows.Count > 0) { strReport.AppendLine("<tr>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >BINDER_ALLOT_CODE</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >BOOK_CODE</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >BinderName</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >LANGUAGE</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >BOOK_NAME</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >ALLOTMENT_DATE</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >TOT_QTY</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >LOT</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >REQ_QTY</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:#b3cbff;' >QTY_ISSUED</th>"); strReport.AppendLine(" <th style='text-align:left;background-color:b3cbff;' >STATUS</th>"); strReport.AppendLine("</tr>"); for (int iCnt = 0; iCnt < dtbinderallot.Rows.Count; iCnt++) { strReport.AppendLine("<tr>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["BINDER_ALLOT_CODE"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["BOOK_CODE"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["BinderName"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["LANGUAGE"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["BOOK_NAME"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["ALLOTMENT_DATE"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["TOT_QTY"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["LOT"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["REQ_QTY"].ToString() + " </td>"); strReport.AppendLine(" <td> " + dtbinderallot.Rows[iCnt]["QTY_ISSUED"].ToString() + " </td>"); strReport.AppendLine(" <td> " + (dtbinderallot.Rows[iCnt]["STATUS"].ToString() == "0" ? "Draft" : "Confirmed") + " </td>"); strReport.AppendLine("</tr>"); } strTableReport.AppendLine("<table border='1'>"); strTableReport.AppendLine(" " + strReport.ToString()); strTableReport.AppendLine("</table>"); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; String FileName = "BinderAllotBooks" + DateTime.Now.Year.ToString() + "_" + DateTime.Now.ToString("dd-MMM-yyyy") + ".xls"; Response.AddHeader("Content-Disposition", "inline;filename=" + FileName); String HTMLDataToExport = strTableReport.ToString(); Response.Write("<html><head><head>" + HTMLDataToExport.Replace("<BR>", "<br style='mso-data-placement:same-cell;'>") .Replace("<br>", "<br style='mso-data-placement:same-cell;'>") .Replace("<BR >", "<br style='mso-data-placement:same-cell;'>") .Replace("<BR />", "<br style='mso-data-placement:same-cell;'>") .Replace("<br />", "<br style='mso-data-placement:same-cell;'>") .Replace("<Br />", "<br style='mso-data-placement:same-cell;'>") .Replace("<Br>", "<br style='mso-data-placement:same-cell;'>") .Replace("<br >", "<br style='mso-data-placement:same-cell;'>") + "</html>"); Response.End(); } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(View()); }