public ActionResult exportToExcelRightsSellingList(RightsSellingSearchModel _mobjOtherContract) { try { List <RightsSellingSearchModel> _mobjReportList = new List <RightsSellingSearchModel>(); RightsSellingSearchModel _mobjParametertList = new RightsSellingSearchModel(); _mobjReportList = GetRightsSellingExcelList(_mobjOtherContract.SessionId).ToList(); _mobjParametertList = GetRightsSellingExcelParameterList(_mobjOtherContract.SessionId); string sFileName = "RightsSelling_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".xls"; { StringBuilder mstr_searchparameter = new StringBuilder(); mstr_searchparameter.Append("<table width='100%'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' align='left' valign='top'>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' valign='top' align=center colspan='2'>" + "<b>Rights Selling Report</b>" + "</td>"); mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 50%;' valign='top' align=left >" + "<b>Number of Records:</b> " + _mobjReportList.Count() + "</td>"); mstr_searchparameter.Append("<td style='width: 50%;' valign='top' align=right >" + "<b>Report Created Date:</b> " + String.Format("{0:dd MMM yy HH:mm:ss}", DateTime.Now) + "</td>"); mstr_searchparameter.Append("</tr>"); if (!String.IsNullOrEmpty(_mobjParametertList.ReturnList)) { mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td colspan='2' style='width: 100%;' valign='top' align=left>" + "<b>" + "Search criteria:-" + "</b>" + _mobjParametertList.ReturnList + "</td>"); mstr_searchparameter.Append("</tr>"); } mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' valign='top' align=center colspan='2'></td>"); mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("</table>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td colspan='2'>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td><b>SNo.</b></td>"); mstr_searchparameter.Append("<td ><b>Right Sales Code</b></td>"); mstr_searchparameter.Append("<td ><b>Product Code</b></td>"); mstr_searchparameter.Append("<td ><b>ISBN</b></td>"); mstr_searchparameter.Append("<td ><b>Working Product</b></td>"); mstr_searchparameter.Append("<td ><b>Author Name</b></td>"); mstr_searchparameter.Append("<td ><b>Contract Code</b></td>"); mstr_searchparameter.Append("<td ><b>Product License Code</b></td>"); mstr_searchparameter.Append("<td><b>Requested Date</b></td>"); mstr_searchparameter.Append("<td><b>Contract Date</b></td>"); mstr_searchparameter.Append("<td ><b>Date of Expiry</b></td>"); mstr_searchparameter.Append("<td ><b>Licensee Name</b></td>"); mstr_searchparameter.Append("<td ><b>Licensee Code </b></td>"); mstr_searchparameter.Append("<td ><b>Contact Person </b></td>"); mstr_searchparameter.Append("<td ><b>Address </b></td>"); mstr_searchparameter.Append("<td ><b>Country </b></td>"); mstr_searchparameter.Append("<td ><b>State </b></td>"); mstr_searchparameter.Append("<td ><b>City </b></td>"); mstr_searchparameter.Append("<td ><b>PIN Code </b></td>"); mstr_searchparameter.Append("<td ><b>Mobile </b></td>"); mstr_searchparameter.Append("<td ><b>Email </b></td>"); mstr_searchparameter.Append("<td ><b>URL </b></td>"); mstr_searchparameter.Append("<td ><b> Request Date </b></td>"); mstr_searchparameter.Append("<td ><b>Will Be Material Be Translated </b></td>"); mstr_searchparameter.Append("<td ><b>Language </b></td>"); mstr_searchparameter.Append("<td ><b> Print Run Quantity Allowed </b></td>"); mstr_searchparameter.Append("<td ><b>Number of Impression </b></td>"); mstr_searchparameter.Append("<td ><b>Advance Payment </b></td>"); mstr_searchparameter.Append("<td ><b>Currency </b></td>"); mstr_searchparameter.Append("<td ><b>Payment Term </b></td>"); mstr_searchparameter.Append("<td ><b>Payment Amount </b></td>"); mstr_searchparameter.Append("<td ><b>Territory </b></td>"); mstr_searchparameter.Append("<td ><b> Advance Royalty Amount</b></td>"); mstr_searchparameter.Append("<td ><b> Royalty Recurring</b></td>"); mstr_searchparameter.Append("<td ><b>Recurring From Period </b></td>"); mstr_searchparameter.Append("<td ><b>Recurring To Period </b></td>"); mstr_searchparameter.Append("<td ><b> Status</b></td>"); mstr_searchparameter.Append("<td ><b> Remarks</b></td>"); mstr_searchparameter.Append("<td ><b>Royalty Type </b></td>"); mstr_searchparameter.Append("<td ><b> Frequency</b></td>"); mstr_searchparameter.Append("<td ><b>Contract Status </b></td>"); mstr_searchparameter.Append("<td ><b>Date of Agreement </b></td>"); mstr_searchparameter.Append("<td ><b>Signed Contract Sent Date </b></td>"); mstr_searchparameter.Append("<td ><b>Signed Contract Received Date </b></td>"); mstr_searchparameter.Append("<td ><b>Cancellation Date </b></td>"); mstr_searchparameter.Append("<td ><b>Cancellation Reason </b></td>"); mstr_searchparameter.Append("<td ><b>Contributor Agreement </b></td>"); mstr_searchparameter.Append("<td ><b>Pending Remarks </b></td>"); mstr_searchparameter.Append("<td ><b>Effective Date </b></td>"); mstr_searchparameter.Append("<td ><b>Contract Period In Month </b></td>"); List <string> typename = new List <string>(); int typenamecounter = 0; if (_mobjReportList.Count > 0) { for (int i = 0; i < _mobjReportList.Count; i++) { if (_mobjReportList[i].RoyaltySlab != null) { string[] slab = _mobjReportList[i].RoyaltySlab.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k++) { if (k % 2 == 0) { typename.Add(slabvalue[k].ToString()); typenamecounter++; } } } } } } List <string> distincttypename = typename.Distinct().ToList(); if (distincttypename.Count > 0) { foreach (string Typenames in distincttypename) { mstr_searchparameter.Append("<td ><b>" + Typenames.ToUpper() + " </b></td>"); } } mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("</td>"); int mint_Counter = 1; int Count_value = 0; foreach (RightsSellingSearchModel data in _mobjReportList) { mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td align='right'>" + mint_Counter + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.RightsSellingCode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ProductCode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + (data.ISBN == null || data.ISBN == "" ? "" : Convert.ToString(" " + data.ISBN)) + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.WorkingProduct + "<br />" + "<span style='font-size:11px;'>" + data.WorkingSubProduct + "</span>" + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AuthorName + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AuthorContractCode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ProductLicensecode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.RequestDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.DateContract + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.DateExpiry + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.OrganizationName + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Licenseecode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ContactPerson + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Address + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Country + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.State + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.City + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Pincode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.LicenseeMobile + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Email + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.URL + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.RequestDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Will_be_material_be_translated + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Language + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Print_Run_Quantity_Allowed + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Number_of_Impression_Allowed + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Advance_Payment + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.CurrencyName + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Payment_Term + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Payment_Amount + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.TerritoryRights + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Advance_Royalty_Amount + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Royalty_Recurring + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Recurring_From_Period + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Recurring_To_Period + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Status + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Remarks + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.RoyaltyType + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Frequency + "</td>"); mstr_searchparameter.Append("<td align='left'>" + (data.ContractStatus == "Pending" ? "Issued" : (data.ContractStatus == "Issued" ? "Received" : data.ContractStatus)) + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Date_of_agreement + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Signed_Contract_sent_date + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Signed_Contract_receiveddate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.CancellationDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Cancellation_Reason + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Contributor_Agreement + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Pending_Remarks + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Effectivedate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Contractperiodinmonth + "</td>"); //if (_mobjReporRoyaltytList.Count > 0) //{ // for (int j = 0; j < distincttypename.Count; j++) // { // string slabdata = ""; // if (_mobjReporRoyaltytList[Count_value].RoyaltySlab != null) // { // string[] slab = _mobjReporRoyaltytList[Count_value].RoyaltySlab.Split(','); // foreach (string s in slab) // { // string[] slabvalue = s.Split('#'); // for (int k = 0; k < slabvalue.Length; k = k + 2) // { // if (slabvalue[k].ToString() == distincttypename[j].ToString()) // slabdata += slabvalue[k + 1].ToString() + ", "; // } // } // if (slabdata.Length > 0) // slabdata = slabdata.Substring(0, slabdata.Length - 2); // mstr_searchparameter.Append("<td align='left'>" + slabdata + "</td>"); // } // else // mstr_searchparameter.Append("<td align='left'></td>"); // } //} if (distincttypename.Count > 0) { for (int j = 0; j < distincttypename.Count; j++) { string slabdata = ""; if (_mobjReportList[Count_value].RoyaltySlab != null) { string[] slab = _mobjReportList[Count_value].RoyaltySlab.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k = k + 2) { if (slabvalue[k].ToString() == distincttypename[j].ToString()) { slabdata += slabvalue[k + 1].ToString() + ", "; } } } if (slabdata.Length > 0) { slabdata = slabdata.Substring(0, slabdata.Length - 2); } mstr_searchparameter.Append("<td align='left'>" + slabdata + "</td>"); } else { mstr_searchparameter.Append("<td align='left'></td>"); } } } mstr_searchparameter.Append("</tr>"); mint_Counter++; Count_value++; } mstr_searchparameter.Append("</table></td></tr></table>"); HttpContext.Response.AddHeader("content-disposition", "attachment; filename=" + sFileName); this.Response.ContentType = "application/excel"; byte[] buffer = System.Text.Encoding.UTF8.GetBytes(mstr_searchparameter.ToString()); return(File(buffer, "application/vnd.ms-excel")); } } catch (Exception ex) { return(null); throw ex; } }
public ActionResult exportToExcelProductLicenseList(ProductLicenseSearch.ClsSearchReport _mobjOtherContract) { try { List <ProductLicenseSearch.ClsSearchReport> _mobjReportList = new List <ProductLicenseSearch.ClsSearchReport>(); ProductLicenseSearch.ClsSearchReport _mobjParametertList = new ProductLicenseSearch.ClsSearchReport(); _mobjReportList = GetProductLicenseExcelList(_mobjOtherContract.SessionId).ToList(); _mobjParametertList = GetProductLicenseExcelParameterList(_mobjOtherContract.SessionId); string sFileName = "ProductLicense_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".xls"; { StringBuilder mstr_searchparameter = new StringBuilder(); mstr_searchparameter.Append("<table width='100%'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' align='left' valign='top'>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' valign='top' align=center colspan='2'>" + "<b>Product License Report</b>" + "</td>"); mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 50%;' valign='top' align=left >" + "<b>Number of Records:</b> " + _mobjReportList.Count() + "</td>"); mstr_searchparameter.Append("<td style='width: 50%;' valign='top' align=right >" + "<b>Report Created Date:</b> " + String.Format("{0:dd MMM yy HH:mm:ss}", DateTime.Now) + "</td>"); mstr_searchparameter.Append("</tr>"); if (!String.IsNullOrEmpty(_mobjParametertList.ReturnList)) { mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td colspan='2' style='width: 100%;' valign='top' align=left>" + "<b>" + "Search criteria:-" + "</b>" + _mobjParametertList.ReturnList + "</td>"); mstr_searchparameter.Append("</tr>"); } mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td style='width: 100%;' valign='top' align=center colspan='2'></td>"); mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("</table>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td colspan='2'>"); mstr_searchparameter.Append("<table width='100%' cellpadding='0' border='1%' cellspacing='0'>"); mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td><b>SNo.</b></td>"); mstr_searchparameter.Append("<td ><b>Product License Code</b></td>"); mstr_searchparameter.Append("<td ><b>Product Code</b></td>"); mstr_searchparameter.Append("<td ><b>Working Title</b></td>"); mstr_searchparameter.Append("<td ><b>Working Sub Title</b></td>"); mstr_searchparameter.Append("<td><b>ISBN</b></td>"); mstr_searchparameter.Append("<td><b>Author Name </b></td>"); mstr_searchparameter.Append("<td><b>Contract Date</b></td>"); mstr_searchparameter.Append("<td ><b>Proprietor Company</b></td>"); mstr_searchparameter.Append("<td ><b>Contact Person</b></td>"); mstr_searchparameter.Append("<td ><b>Address</b></td>"); mstr_searchparameter.Append("<td ><b>Country</b></td>"); mstr_searchparameter.Append("<td ><b>State</b></td>"); mstr_searchparameter.Append("<td ><b>City</b></td>"); mstr_searchparameter.Append("<td ><b>PIN Code</b></td>"); mstr_searchparameter.Append("<td ><b>Mobile</b></td>"); mstr_searchparameter.Append("<td ><b>Email</b></td>"); mstr_searchparameter.Append("<td ><b>Request Date</b></td>"); mstr_searchparameter.Append("<td ><b>Territory Rights</b></td>"); mstr_searchparameter.Append("<td ><b>Impression With In Date</b></td>"); mstr_searchparameter.Append("<td ><b>No of Impressions</b></td>"); mstr_searchparameter.Append("<td ><b>Print Quantity Type</b></td>"); mstr_searchparameter.Append("<td ><b>Print Quantity</b></td>"); mstr_searchparameter.Append("<td ><b>Royality Terms</b></td>"); mstr_searchparameter.Append("<td ><b>Payment Amount</b></td>"); mstr_searchparameter.Append("<td ><b>Advanced Amount</b></td>"); mstr_searchparameter.Append("<td ><b>Copies For Proprietor</b></td>"); mstr_searchparameter.Append("<td ><b>Price Type</b></td>"); mstr_searchparameter.Append("<td ><b>Currency</b></td>"); mstr_searchparameter.Append("<td ><b>Price</b></td>"); mstr_searchparameter.Append("<td ><b>Third Party Permission</b></td>"); mstr_searchparameter.Append("<td ><b>Remarks</b></td>"); mstr_searchparameter.Append("<td ><b>Proprietor Copies Sent Date</b></td>"); mstr_searchparameter.Append("<td ><b>EFiles Cost</b></td>"); mstr_searchparameter.Append("<td ><b>EFiles Request Date</b></td>"); mstr_searchparameter.Append("<td ><b>EFiles Received Date</b></td>"); mstr_searchparameter.Append("<td ><b>Mode</b></td>"); mstr_searchparameter.Append("<td ><b>Effective Date</b></td>"); mstr_searchparameter.Append("<td ><b>Agreement Date</b></td>"); mstr_searchparameter.Append("<td ><b>Contract Period In Month</b></td>"); mstr_searchparameter.Append("<td ><b>Expiry Date</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Code</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Date</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Type</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum First Impression With in Date</b></td>"); //mstr_searchparameter.Append("<td ><b>Addendum Period of Agreement</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Expiry Date</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum No of Impressions</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Balance Quantity Carry Forward</b></td>"); mstr_searchparameter.Append("<td ><b>Additional Number of Copies</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Royalty Terms</b></td>"); mstr_searchparameter.Append("<td ><b>Addendum Remarks</b></td>"); List <string> typename = new List <string>(); List <string> subsiadiryname = new List <string>(); if (_mobjReportList.Count > 0) { for (int i = 0; i < _mobjReportList.Count; i++) { if (_mobjReportList[i].RoyaltySlab != null) { string[] slab = _mobjReportList[i].RoyaltySlab.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k++) { if (k % 2 == 0) { typename.Add(slabvalue[k].ToString()); } } } } if (_mobjReportList[i].SubsidiaryRights != null) { string[] slab = _mobjReportList[i].SubsidiaryRights.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k++) { if (k % 2 == 0) { subsiadiryname.Add(slabvalue[k].ToString()); } } } } } } List <string> distincttypename = typename.Distinct().ToList(); if (distincttypename.Count > 0) { foreach (string Typenames in distincttypename) { mstr_searchparameter.Append("<td ><b>" + Typenames.ToUpper() + " </b></td>"); } } List <string> distinctsubsiadiryname = subsiadiryname.Distinct().ToList(); if (distinctsubsiadiryname.Count > 0) { foreach (string subsiadirynames in distinctsubsiadiryname) { mstr_searchparameter.Append("<td ><b>" + subsiadirynames.ToUpper() + " </b></td>"); } } mstr_searchparameter.Append("</tr>"); mstr_searchparameter.Append("</td>"); int mint_Counter = 1; int Count_value = 0; foreach (ProductLicenseSearch.ClsSearchReport data in _mobjReportList) { mstr_searchparameter.Append("<tr>"); mstr_searchparameter.Append("<td align='right'>" + mint_Counter + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.productlicensecode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.productcode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.WorkingTitle + "<br />" + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.WorkingSubProduct + "<br />" + "</td>"); mstr_searchparameter.Append("<td align='left'>" + (data.OUPISBN == null || data.OUPISBN == "" ? "" : Convert.ToString(" " + data.OUPISBN)) + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AuthorName + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ContractDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ProprietorCompany + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.ContactPerson + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Address + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Country + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.State + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.City + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Pincode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Mobile + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Email + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Requestdate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.TerritoryRights + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Impressionwithindate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.noofimpressions + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.printquantitytype + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.printquantity + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.RoyalityTerms + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.PaymentAmount + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AdvancedAmount + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.copiesforlicensor + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.pricetype + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Currencyid + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.price + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.thirdpartypermission + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Remarks + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.LicensorCopiesSentDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.EFilesCost + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.EFilesRequestDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.EFilesReceivedDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Mode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.effectivedate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AgreementDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.contractperiodinmonth + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.Expirydate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumCode + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumType + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumFirstImpressionWithinDate + "</td>"); //mstr_searchparameter.Append("<td align='left'>" + data.AddendumPeriodofagreement + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumExpiryDate + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumNoOfImpressions + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumBalanceQuantityCarryForward + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumQuantity + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumRoyaltyTerms + "</td>"); mstr_searchparameter.Append("<td align='left'>" + data.AddendumRemarks + "</td>"); if (distincttypename.Count > 0) { for (int j = 0; j < distincttypename.Count; j++) { string slabdata = ""; if (_mobjReportList[Count_value].RoyaltySlab != null) { string[] slab = _mobjReportList[Count_value].RoyaltySlab.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k = k + 2) { if (slabvalue[k].ToString() == distincttypename[j].ToString()) { slabdata += slabvalue[k + 1].ToString() + ", "; } } } if (slabdata.Length > 0) { slabdata = slabdata.Substring(0, slabdata.Length - 2); } mstr_searchparameter.Append("<td align='left'>" + slabdata + "</td>"); } else { mstr_searchparameter.Append("<td align='left'></td>"); } } } if (distinctsubsiadiryname.Count > 0) { for (int j = 0; j < distinctsubsiadiryname.Count; j++) { string slabdata = ""; if (_mobjReportList[Count_value].SubsidiaryRights != null) { string[] slab = _mobjReportList[Count_value].SubsidiaryRights.Split(','); foreach (string s in slab) { string[] slabvalue = s.Split('#'); for (int k = 0; k < slabvalue.Length; k = k + 2) { if (slabvalue[k].ToString() == distinctsubsiadiryname[j].ToString()) { slabdata += slabvalue[k + 1].ToString() + ", "; } } } if (slabdata.Length > 0) { slabdata = slabdata.Substring(0, slabdata.Length - 2); } mstr_searchparameter.Append("<td align='left'>" + slabdata + "</td>"); } else { mstr_searchparameter.Append("<td align='left'></td>"); } } } mstr_searchparameter.Append("</tr>"); mint_Counter++; Count_value++; } mstr_searchparameter.Append("</table></td></tr></table>"); HttpContext.Response.AddHeader("content-disposition", "attachment; filename=" + sFileName); this.Response.ContentType = "application/excel"; byte[] buffer = System.Text.Encoding.UTF8.GetBytes(mstr_searchparameter.ToString()); return(File(buffer, "application/vnd.ms-excel")); } } catch (Exception ex) { return(null); throw ex; } }