protected void btnExportExcel_Click(object sender, EventArgs e)
{
string ReportName;
if (Session["ReportName"] != null)
{
ReportName = Session["ReportName"].ToString();
}
else
{
ReportName = "";
}
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", ReportName + ".xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
//BindGridDetails(gvCheckList);
form.Attributes["runat"] = "server";
switch (ReportName)
{
case "Skill Count":
gvSkillCount.AllowPaging = false;
form.Controls.Add(gvSkillCount);
break;
case "Skill Detail":
gvSkillDetail.AllowPaging = false;
form.Controls.Add(gvSkillDetail);
break;
case "Skill Type Count":
gvSkillTypeCount.AllowPaging = false;
form.Controls.Add(gvSkillTypeCount);
break;
case "Skill Type Detail":
gvSkillTypeDetail.AllowPaging = false;
form.Controls.Add(gvSkillTypeDetail);
break;
default:
break;
}
this.Controls.Add(form);
form.RenderControl(hw);
string style = @"<!--mce:2-->";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnExcel_Click(object sender, EventArgs e)
{
try
{
ChangeControlsToValue(gvDeposits);
// gvDeposits.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=AgentDeposits.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
gvDeposits.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(gvDeposits);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
//gvDeposits.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
//Export to Excel from a gridview
public static void ExportToExcel(GridView gv, Page pag)
{
char c = (char)34;
char bk = '\n';
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
System.Web.HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=RotationPublications.xls");
System.Web.HttpContext.Current.Response.Write("<!DOCTYPE html>" + bk +
"<html>" + bk +
"<head>" + bk + "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>" + bk + "</head><body>");
pag.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
pag.Controls.Add(frm);
frm.Controls.Add(gv);
frm.RenderControl(htw);
System.Web.HttpContext.Current.Response.Write(sw.ToString());
System.Web.HttpContext.Current.Response.End();
}
protected void btnPrintPDF_Click(object sender, EventArgs e)
{
string attachment = "attachment; filename=Export.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
divMon.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(divMon);
frm.RenderControl(htw);
//GridView_Merge_Header.Parent.Controls.Add(frm);
//frm.Attributes["runat"] = "server";
//frm.Controls.Add(GridView_Merge_Header);
//frm.RenderControl(htw);
////GridView_Merge_Header.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected void btnWord_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", "Student.doc"));
Response.ContentType = "application/ms-msword";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
BindGridDetails(GridView1);
form.Attributes["runat"] = "server";
form.Controls.Add(GridView1);
this.Controls.Add(form);
form.RenderControl(hw);
string style = @"<style> .textmode { mso-number-format:\@;}</style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void BtnDownloadAttendanceAsExcel_Click(object sender, EventArgs e)
{
if (int.Parse(DDLSemester.SelectedValue.ToString()) % 2 == 0)
LblSemesterType.Text = "EVEN SEMESTER";
else
LblSemesterType.Text = "ODD SEMESTER";
LblDepartment.Text = Session["Department"].ToString();
LblFromDate.Text = TxtBxFromDate.Text;
LblToDate.Text = TxtBxToDate.Text;
LblSection.Text = DDLSection.SelectedItem.Text;
LblSemester.Text = DDLSemester.SelectedItem.Text;
string name = DDLSection.SelectedItem.ToString().Replace(" ", "") + ".xls";
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=" + name;
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(ListHeader);
form.Controls.Add(GridView1);
this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["EventID"] != null)
{
long eventId = Convert.ToInt64(Request.QueryString["EventID"]);
var eventCustomerReportingService = IoC.Resolve <IEventCustomerReportingService>();
var rescheduledCustomers = eventCustomerReportingService.GetRescheduleAppointmentsForEvent(eventId);
BindCustomerList(rescheduledCustomers);
HtmlForm newForm = this.form1;
newForm.Controls.Clear();
newForm.Controls.Add(div1);
var sb = new System.Text.StringBuilder();
var htWriter = new HtmlTextWriter(new System.IO.StringWriter(sb));
newForm.RenderControl(htWriter);
string strRenderedHtml = sb.ToString();
strRenderedHtml = strRenderedHtml.Substring(strRenderedHtml.IndexOf("<div id=\"div1\""), strRenderedHtml.LastIndexOf("</div") - strRenderedHtml.IndexOf("<div id=\"div1\"") + 6);
Response.Write(strRenderedHtml);
}
Response.End();
}
protected void img_btnmacexcel_Click(object sender, ImageClickEventArgs e)
{
lock (thisLock)
{
try
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Machine.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
//Applying stlye to gridview header cells
for (int i = 0; i < GridView1.HeaderRow.Cells.Count; i++)
{
GridView1.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");
}
GridView1.AllowPaging = false;
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
} catch (Exception ex)
{
ExceptionLogging.SendExcepToDB(ex);
}
finally
{
}
}
}
private void ExportGridToExcel()
{
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "Defaulters" + DateTime.Now.ToShortDateString() + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
gvdaybook.GridLines = GridLines.Both;
gvdaybook.HeaderStyle.Font.Bold = true;
gvdaybook.RenderControl(htmltextwrtter);
gvdaybook.AllowPaging = false;
form.Attributes["runat"] = "server";
form.Controls.Add(gvdaybook);
this.Controls.Add(form);
form.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
private void ExportGridView(RadGrid whichgrid)
{
string attachment = "attachment; filename=Routes.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
whichgrid.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(whichgrid);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
private void ExportToExcel()
{
//ToolScriptManager
Response.Clear();
Response.Charset = "";
//Response.ContentType = "application/vnd.ms-excel"
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("Content-Disposition", "attachment; filename=Invoice_" + invoiceNo.ToString() + ".xls");
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
dg = new DataGrid();
dg = item_list;
dg.GridLines = GridLines.None;
dg.HeaderStyle.Font.Bold = true;
dg.Visible = true;
dg.AllowPaging = false;
dg.AllowSorting = false;
LoadView();
HtmlForm frm = new HtmlForm();
dg.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(dg);
frm.RenderControl(hw);
Response.Write(sw);
Response.End();
}
//protected void gvCalendar_RowDataBound(object sender, GridViewRowEventArgs e)
//{
//}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", "LARPCalendar.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gvCalendar.AllowPaging = false;
//BindGridDetails(gvCalendar);
form.Attributes["runat"] = "server";
form.Controls.Add(gvCalendar);
this.Controls.Add(form);
form.RenderControl(hw);
string style = @"<!--mce:2-->";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void Button4_Click(object sender, EventArgs e)
{
try
{
if (GridView1.Visible == true)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Meal_Calculation.pdf");
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
// GridView1.AllowPaging = false;
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
// frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(hw);
// GridView1.DataBind();
StringReader sr = new StringReader(sw.ToString());
iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(PageSize.A4, 10f, 10f, 10f, 10f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
catch (Exception ex)
{
Response.Write("Please select date");
}
}
protected void btnWord_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
//Response.Clear();
//Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.doc");
Response.ContentType = "application/ms-word";
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
//set font
HttpContext.Current.Response.Write("<font style='font-size:10.0pt; font-family:Calibri;'>");
HttpContext.Current.Response.Write("<BR><BR><BR>");
//Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
// Bỏ phân trang - Nếu chỉ muỗn Export Trang hiện hành thì chọn =true
form.Controls.Add(grDSSum);
this.Controls.Add(form);
form.RenderControl(hw);
//grDSSum.RenderControl(hw);
//Thay đổi Style
hw.WriteLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
Response.Write(sw.ToString());
//Response.Flush();
Response.End();
}
protected void Export_Excel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "RestausantsExcel_" + DateTime.Now + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
HtmlForm form1 = new HtmlForm();
Page.Controls.Add(form1);
GridView1.GridLines = GridLines.Both;
GridView1.HeaderStyle.Font.Bold = true;
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
form1.Controls.Add(GridView1);
form1.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
GridView1.AllowPaging = true;
GridView1.AllowSorting = true;
}
protected void Button3_Click(object sender, EventArgs e)
{
if (GridView1.Visible == true)
{
try {
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", "Meal_Calculation.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
// BindGridDetails(GridView1);
form.Attributes["runat"] = "server";
form.Controls.Add(GridView1);
this.Controls.Add(form);
form.RenderControl(hw);
string style = @"<!--mce:2-->";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex)
{
Response.Write("Please select date");
}
}
}
public void ExportPdf(System.Web.UI.WebControls.GridView exportGV, System.Web.HttpResponse Response, System.Web.UI.HtmlControls.HtmlForm htmlForm)
{
string strFileName = "PDFReport-" + System.DateTime.Now.Date.ToString("dd") + System.DateTime.Now.AddMonths(0).ToString("MM") + System.DateTime.Now.AddYears(0).ToString("yyyy");
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=" + strFileName + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
exportGV.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(exportGV);
frm.RenderControl(hw);
StringReader sr = new StringReader(Regex.Replace(sw.ToString(), "<script.*?</script>", "", RegexOptions.Singleline | RegexOptions.IgnoreCase));
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
private void ExportGridView()
{
string attachment = "attachment; filename=Dist_Peace_Leadership_Registration_Cheque_Report.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htw);
//GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void ExportToExcelG(GridView GridName, HtmlForm frmForm, string StrHeading, string ExcelWord)
{
string attachment;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<Head align='center' style='font-weight:bold;font-family:Arial;font-size:16'>" + StrHeading + " </head>");
HtmlForm form = new HtmlForm();
if (ExcelWord == "Word")
{
attachment = "attachment; filename=" + GridName.ID + ".doc";
HttpContext.Current.Response.ContentType = "application/ms-word";
}
else if (ExcelWord == "pdf")
{
attachment = "attachment; filename=" + GridName.ID + ".pdf";
HttpContext.Current.Response.ContentType = "application/pdf";
}
else
{
attachment = "attachment; filename=" + GridName.ID + ".xls";
HttpContext.Current.Response.ContentType = "application/ms-excel";
}
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
StringWriter stw = new StringWriter(sb);
HtmlTextWriter htextw = new HtmlTextWriter(stw);
GridName.BorderWidth = 0;
form.Controls.Add(GridName);
frmForm.Controls.Add(form);
form.RenderControl(htextw);
HttpContext.Current.Response.Write(stw.ToString());
HttpContext.Current.Response.End();
}
private void ExportGridView(string Filetype)
{
LatestValuationdate = Convert.ToDateTime(ViewState["Valuationdate"].ToString());
//LatestValuationdate = Convert.ToDateTime(ValuationDate.Value.ToString());
HtmlForm frm = new HtmlForm();
frm.Controls.Clear();
frm.Attributes["runat"] = "server";
if (Filetype == "Excel")
{
gvMFMIS.Columns.Remove(this.gvMFMIS.Columns[0]);
string temp = rmVo.FirstName + rmVo.LastName + "'s_MF_MIS.xls";
string attachment = "attachment; filename=" + temp;
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
//Add details for the header
Response.Output.Write("<table border=\"0\"><tbody><tr><td>");
Response.Output.Write("Report : ");
Response.Output.Write("</td>");
Response.Output.Write("<td><b>");
Response.Output.Write("AMC/Schemewise AUM</b>");
Response.Output.Write("</td></tr><tr><td>");
Response.Output.Write("As on Date : ");
Response.Output.Write("</td><td><b>");
System.DateTime tDate1 = LatestValuationdate;
Response.Output.Write(tDate1.ToShortDateString());
Response.Output.Write("</b></td></tr>");
Response.Output.Write("</tbody></table>");
PrepareGridViewForExport(gvMFMIS);
if (gvMFMIS.HeaderRow != null)
{
PrepareControlForExport(gvMFMIS.HeaderRow);
}
foreach (GridViewRow row in gvMFMIS.Rows)
{
PrepareControlForExport(row);
}
if (gvMFMIS.FooterRow != null)
{
PrepareControlForExport(gvMFMIS.FooterRow);
}
gvMFMIS.Parent.Controls.Add(frm);
frm.Controls.Add(gvMFMIS);
frm.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
Response.Clear();
Response.Buffer = true;
string attachment = null;
attachment = "attachment; filename=Product.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = null;
sw = new StringWriter();
HtmlTextWriter htw = default(HtmlTextWriter);
htw = new HtmlTextWriter(sw);
HtmlForm frm = default(HtmlForm);
frm = new HtmlForm();
grdData.HeaderStyle.Width = Unit.Pixel(20); //here use your gridview control id
grdData.Parent.Controls.Add(frm); //here use your gridview control id
frm.Attributes["runat"] = "server";
frm.Controls.Add(grdData); //here use your gridview control id
grdData.AllowPaging = false; //here use your gridview control id
grdData.AllowSorting = false; //here use your gridview control id
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
catch { }
finally { }
}
private void ExportGridView(string Filetype)
{
{
HtmlForm frm = new HtmlForm();
System.Web.UI.WebControls.Table tbl = new System.Web.UI.WebControls.Table();
frm.Controls.Clear();
frm.Attributes["runat"] = "server";
if (Filetype.ToLower() == "excel")
{
string temp = "Equity_Transactions.xls";
string attachment = "attachment; filename=" + temp;
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Response.Output.Write("<table border=\"0\"><tbody ><caption align=\"left\"><FONT FACE=\"ARIAL\" SIZE=\"4\">");
Response.Output.Write("Equity Transactions for " + convertedFromDate.ToString("MMM-dd-yyyy") + " to " + convertedToDate.ToString("MMM-dd-yyyy") + "</FONT></caption>");
Response.Output.Write("<tr><td>");
Response.Output.Write("Report Generated on : ");
Response.Output.Write(DateTime.Now.ToString("MMM-dd-yyyy hh:ss tt"));
Response.Output.Write("</td></tr>");
Response.Output.Write("</tbody></table>");
PrepareGridViewForExport(gvMFTransactions);
if (gvMFTransactions.HeaderRow != null)
{
PrepareControlForExport(gvMFTransactions.HeaderRow);
}
foreach (GridViewRow row in gvMFTransactions.Rows)
{
PrepareControlForExport(row);
}
if (gvMFTransactions.FooterRow != null)
{
PrepareControlForExport(gvMFTransactions.FooterRow);
}
gvMFTransactions.Parent.Controls.Add(frm);
frm.Controls.Add(gvMFTransactions);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
}
}
private void ExportGridView()
{
string attachment = "attachment; filename=TRF_Seminar_Reg_Club_Wise_Report.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
string paymentType = rbtnType.SelectedValue.ToString();
if (paymentType == "0")
{
frm.Controls.Add(GridView1);
}
if (paymentType == "1")
{
frm.Controls.Add(GridView2);
}
if (paymentType == "2")
{
frm.Controls.Add(GridView3);
}
frm.RenderControl(htw);
//GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
private void RenderCalendarData()
{
HtmlForm calendarForm = form1;
calendarForm.Controls.Clear();
calendarForm.Controls.Add(dvCalendar);
var formatProvider = new StringBuilder();
var htmlTextWriter = new HtmlTextWriter(new StringWriter(formatProvider));
calendarForm.RenderControl(htmlTextWriter);
string renderedHtml = formatProvider.ToString();
renderedHtml = renderedHtml.Substring(renderedHtml.IndexOf("<div id=\"dvCalendar\""), renderedHtml.LastIndexOf("</div>") - renderedHtml.IndexOf("<div id=\"dvCalendar\"") - 92);
Response.Write(renderedHtml);
}
protected void ExportDupes(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Duplicates.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
newForm.Controls.Add(gvDupes);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
}
protected void btnSearch1_Click(object sender, EventArgs e)
{
DataTable dt1 = new DataTable();
GridView GrdReportData = new GridView();
GrdReportData.AllowPaging = false;
string Status = GetCheckBoxValues(ddlStatus);
dt1 = CM_Main.CM_SelectTotalRecords(DtStartDate.SelectedDate.Value, DtEndDate.SelectedDate.Value, ddlBranch.SelectedItem.Value, ddlSystemType.SelectedItem.Value, Status, "");
GrdReportData.DataSource = dt1;
GrdReportData.DataBind();
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=TotalIT_Register.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(GrdReportData);
this.Controls.Add(form);
form.RenderControl(htextw);
string headerTable = "Total Records Report";
Response.Write(headerTable);
string StartDate1 = "--Start Date:" + DtStartDate.SelectedDate.Value;
string EndDate1 = "--End Date:" + DtEndDate.SelectedDate.Value;
string rows = "--Total Records:" + GrdReportData.Rows.Count.ToString();
Response.Write(StartDate1);
Response.Write(EndDate1);
Response.Write(rows);
Response.Write(stw.ToString());
Response.End();
}
protected void Button2_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
// string filename="GridViewExport_"+DateTime.Now.ToString()+".xls";
string filename = pcode + "-" + "Agent Id:" + d1 + "RateChartName:" + DateTime.Now.ToString() + ".xls";
Response.AddHeader("content-disposition",
"attachment;filename=" + filename);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
form.Controls.Add(GridView1);
this.Controls.Add(form);
form.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnIncomeExpence_Click(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=IncomeExpense.xls");
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
GridView grd = gvIncomeExpense;
grd.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(grd);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected void Button2_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=Patients.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(gridview1);
this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();
}
protected void Button1_Click(object sender, EventArgs e)
{
string attachment = "attachment; filename=User.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
private void RenderCalendarDetail()
{
HtmlForm newForm = this.form1;
newForm.Controls.Clear();
newForm.Controls.Add(divPodCalendar);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
HtmlTextWriter htWriter = new HtmlTextWriter(new System.IO.StringWriter(sb));
newForm.RenderControl(htWriter);
string strRenderedHTML = sb.ToString();
strRenderedHTML = strRenderedHTML.Substring(strRenderedHTML.IndexOf("<div id=\"divPodCalendar\""), strRenderedHTML.LastIndexOf("</div") - strRenderedHTML.IndexOf("<div id=\"divPodCalendar\"") + 6);
Response.Write(strRenderedHTML);
}
protected void ButtonSpeakerNominationExport_Click(object sender, EventArgs e)
{
DateTime regDate = DateTime.Now;
string strDate = regDate.ToString("ddMMMyyyy");
string fileName = "SpeakerNomination_Export" + strDate + ".xls";
// activate the full data GridView
gvSpeakerNominationAll.Visible = true;
// Let's hide all unwanted stuffing
gvSpeakerNominationAll.AllowPaging = false;
gvSpeakerNominationAll.AllowSorting = false;
// gvShortCourseAll.Columns(0).Visible = False
// Let's bind data to GridView
SqlDataSourceSpeakerNominationExport.DataBind();
gvSpeakerNominationAll.DataBind();
// Let's output HTML of GridView
Response.Clear();
Response.AddHeader("Transfer-Encoding", "identity"); // This line added 06-08-2018 to fix Chrome file download Network Failed error
Response.ContentType = "application/vnd.xls";
Response.ContentEncoding = System.Text.Encoding.Unicode;
Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
StringWriter swriter = new StringWriter();
HtmlTextWriter hwriter = new HtmlTextWriter(swriter);
HtmlForm frm = new HtmlForm();
gvSpeakerNominationAll.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(gvSpeakerNominationAll);
frm.RenderControl(hwriter);
Response.Write(swriter.ToString());
Response.End();
gvSpeakerNominationAll.Visible = false;
}
public void grid2()
{
HtmlForm form = new HtmlForm();
Response.Clear();
Response.Buffer = true;
string filename1 = pcode + "-" + "Missing Agent From:" + txt_FromDate.Text + " To: " + txt_ToDate.Text + ".xls";
Response.AddHeader("content-disposition",
"attachment;filename=" + filename1);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView2.AllowPaging = false;
GridView2.DataBind();
form.Controls.Add(GridView2);
this.Controls.Add(form);
form.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnExportWarning_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=NotFound.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
DataTable dtNotFound = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("Select oldUserName, newUserName from Port_UsernameReplaceGroup where PortfolioID is null");
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
gvWarnings.DataSource = dtNotFound;
gvWarnings.DataBind();
newForm.Controls.Add(gvWarnings);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
}
protected void Btn_ClickExport(object sender, EventArgs e)
{
if (((DataTable)Session["WorkingPIDs"]).Rows.Count > 0)
{
DataTable dtTemp = (DataTable)Session["WorkingPIDs"];
System.Text.StringBuilder sbPIDs = new System.Text.StringBuilder();
sbPIDs.Append("(0");
for (int c = 0; c < dtTemp.Rows.Count; c++)
sbPIDs.Append("," + dtTemp.Rows[c][0]);
sbPIDs.Append(")");
System.Text.StringBuilder sbExportSQL = new System.Text.StringBuilder();
sbExportSQL.Append("SELECT p.PortfolioID,UserName ,[PassWord] ,FirstName, LastName, GradeNumber, GenderID, Active,SchoolID,");
sbExportSQL.Append("LastLogin,s.Percentage,EmailAddress,Address1 ,City ,StateProv, CreateDate,TransferSchoolId ,TransferUserName ,Transferdate,");
sbExportSQL.Append("SchoolUserName ,SchoolPassword FROM dbo.Portfolio p");
sbExportSQL.Append(" JOIN PCSStatus s on p.PortfolioID=s.PortfolioID where p.PortfolioID in " + sbPIDs.ToString());
if (hidSort.Value.Length > 0)
{
sbExportSQL.Append(" order by " + hidSort.Value);
if (!(hidSort.Value == "LastName"))
sbExportSQL.Append(" , LastName");
}
else
sbExportSQL.Append(" order by Username, LastName, FirstName ");
DataTable dtExport = DataAccess.GetDataTable(sbExportSQL.ToString());
gvExport.DataSource = dtExport;
gvExport.DataBind();
// Export the data table
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Export.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
newForm.Controls.Add(gvExport);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
}
}
protected void Btn_ClickExport(object sender, EventArgs e)
{
if (((DataTable)Session["WorkingPIDs"]).Rows.Count > 0)
{
DataTable dtTemp = (DataTable)Session["WorkingPIDs"];
System.Text.StringBuilder sbPIDs = new System.Text.StringBuilder();
sbPIDs.Append("(0");
for (int c = 0; c < dtTemp.Rows.Count; c++)
sbPIDs.Append("," + dtTemp.Rows[c][0]);
sbPIDs.Append(")");
System.Text.StringBuilder sbExportSQL = new System.Text.StringBuilder();
sbExportSQL.Append("Select [ID],CourseName,CourseCredit, CourseTerm, CourseType, CourseCategory, CourseNumber, SchoolID,");
sbExportSQL.Append("CourseDesc, Okay9, Okay10, Okay11, Okay12 FROM PortfolioCourse ");
sbExportSQL.Append(" where [ID] in " + sbPIDs.ToString());
if (hidSort.Value.Length > 0)
{
sbExportSQL.Append(" order by " + hidSort.Value);
if (!(hidSort.Value == "CourseName"))
sbExportSQL.Append(" , CourseName");
}
else
sbExportSQL.Append(" order by CourseName");
DataTable dtExport = DataAccess.GetDataTable(sbExportSQL.ToString());
gvExport.DataSource = dtExport;
gvExport.DataBind();
// Export the data table
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Export.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
newForm.Controls.Add(gvExport);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Server.ScriptTimeout = 1000000;
if (!IsPostBack)
{
if (Strings.GetFormString("hidExportType").Length > 0)
{
#region export file
Response.Write("Export the file.");
string strExportType = Strings.GetFormString("hidExportType");
string strExportSQL = GetExportSQL(strExportType);
DataTable dtExport = DataAccess.GetDataTable(strExportSQL);
gvExport.DataSource = dtExport;
gvExport.DataBind();
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Errors.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
newForm.Controls.Add(gvExport);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
#endregion
}
else
{
string strGroupID = Strings.GetQueryString("G");
GroupInfo.GroupID = strGroupID;
hidGroupID.Value = strGroupID;
hidImportType.Value = Strings.GetQueryString("T");
}
}
else
{
GroupInfo.GroupID = hidGroupID.Value;
pnlEmailChoice.Visible = true;
pnlEmailOptions.Visible = false;
if (hidImportConfirmed.Value == "1")
{
strSchoolGroupList = GetSchoolListSQL(hidGroupID.Value);
System.Text.StringBuilder sbInsertSQL = new System.Text.StringBuilder();
// do the import
if (hidImportType.Value == "5")
{
// Insert new Portfolios
sbInsertSQL.Append(GetInsertSQL(rdIncludeEmails1.Checked));
sbInsertSQL.Append(";Update Port_AutoImportExecutions set ExecutionDate=GetDate() where ExecutionID=" + hidExecutionID.Value);
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Added'," + lblStudentsAdded.Text + "," + hidExecutionID.Value + ")");
}
else if (hidImportType.Value == "4")
{
// deactivate existing portfolios that have duplicate rows in the imoprt file
sbInsertSQL.Append("update Portfolio set Active=0 from Port_AutoImportHoldingTank2 a ");
sbInsertSQL.Append("join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where ErrorMsg='Duplicate Username in File'");
if (hidIncEmails.Value == "1" && hidOverwrite.Value == "1")
{
// Include & Override emails
sbInsertSQL.Append(";update Portfolio set EmailAddress= a.Email, Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword ");
sbInsertSQL.Append("from Port_AutoImportHoldingTankView a join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID join Userinfo u on u.SchoolID=p.SchoolID where a.ErrorMsg is null and u.CPSystemNameID=" + hidGroupID.Value);
}
else
{
// Don't include emails in update
sbInsertSQL.Append(";update Portfolio set Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword ");
sbInsertSQL.Append("from Port_AutoImportHoldingTankView a join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID join Userinfo u WITH (NOLOCK) on u.SchoolID=p.SchoolID where a.ErrorMsg is null and u.CPSystemNameID=" + hidGroupID.Value);
}
// WARNING: This step has the potential to turn off thousands of portfolios!
// Deactivate Portfolios that aren't in the import file
sbInsertSQL.Append(";update Portfolio set Active=0 where SchoolID in " + strSchoolGroupList + " and PortfolioID not in ");
sbInsertSQL.Append(" (select PortfolioID from Port_AutoImportHoldingTank2 where PortfolioID is not null);");
// Insert new Portfolios
sbInsertSQL.Append(GetInsertSQL(hidIncEmails.Value == "1"));
sbInsertSQL.Append(";Update Port_AutoImportExecutions set ExecutionDate=GetDate() where ExecutionID=" + hidExecutionID.Value);
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Added'," + lblStudentsAdded.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Deactivated'," + lblStudentsDeactivated.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Changed Grade'," + lblStudentsChangedGrades.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Changed School'," + lblStudentsChangedSchools.Text + "," + hidExecutionID.Value + ")");
}
//Response.Write(sbInsertSQL.ToString());
SqlConnection insertConnection = new SqlConnection(ConfigurationManager.AppSettings["strConLocal"]);
SqlCommand insertCommand = new SqlCommand(sbInsertSQL.ToString(), insertConnection);
insertCommand.CommandTimeout = 24000;
insertConnection.Open();
insertCommand.ExecuteNonQuery();
insertConnection.Close();
insertCommand = null;
insertConnection = null;
string strPCSSQL = "Insert PCSChangedSchools (SchoolID, ChangeTime) SELECT SchoolID, GETDATE() FROM userinfo WHERE CPSystemNameID=" + hidGroupID.Value;
DataAccess.ExecuteDb(strPCSSQL);
pnlEmailChoice.Visible = false;
pnlExport.Visible = false;
pnlEmailOptions.Visible = false;
pnlValidationStats.Visible = true;
pnlErrorsIssues.Visible = false;
trFinished.Visible = true;
}
else
{
if (fuFile.FileName.Length > 0)
{
//string strFile = fuFile.FileName;
//string strPath = "d:\\Transfer\\ImportUploads\\" + strFile;
//DataAccess.ExecuteDb("Truncate table Port_AutoImportHoldingTank2");
//fuFile.SaveAs(strPath);
// Get the password type!!!
//string strPwdType = DataAccess.GetValue("SELECT Passwordtype FROM dbo.CP_SystemName WHERE SystemNameID=" + hidGroupID.Value).ToString();
//DataTable ImportData = PopulateDataTable(strFile);
//if (strPwdType == "1")
//{
// Random passwords need to be added and columns re-arranged
// ImportData.Columns[7].SetOrdinal(5);
//}
//string strConnectionString = System.Configuration.ConfigurationSettings.AppSettings["strConLocal"].ToString();
//using (SqlBulkCopy MoveXLSData = new SqlBulkCopy(strConnectionString))
// {
// MoveXLSData.DestinationTableName = "Port_AutoImportHoldingTank2";
// MoveXLSData.WriteToServer(ImportData);
// }
//
// System.IO.File.Delete(strPath);
// Update errors, stats, validate
pnlEmailChoice.Visible = false;
DataTable dtGroupSchools = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("Select SchoolID from UserInfo where CPSystemNameID=" + hidGroupID.Value);
string strPrefix = CareerCruisingWeb.CCLib.Common.DataAccess.GetValue("Select UsernamePrefix from CP_SystemName where SystemNameID=" + hidGroupID.Value).ToString();
string strBeginSQL = "Update port_autoimportholdingtank2 set StudentID=Replace(StudentID,'" + strPrefix + "','');Update port_autoimportholdingtank2 set StudentID='" + strPrefix + "' + StudentID;";
strBeginSQL += "update Port_AutoImportHoldingTank2 set SchoolIDFromCode = u.SchoolID from Userinfo u join Port_AutoImportHoldingTank2 p on p.AIExternalCode=u.AutoImportExternalCode and u.CPSystemNameID=" + hidGroupID.Value + ";Insert Port_AutoImportExecutions (PackageID, GroupID) Values (" + hidImportType.Value + " , " + hidGroupID.Value + ");select @@identity";
int intExecutionID = CareerCruisingWeb.CCLib.Common.DataAccess.ExecuteDbWithIntResult(strBeginSQL);
hidExecutionID.Value = intExecutionID.ToString();
if (dtGroupSchools.Rows.Count > 0)
{
strSchoolGroupList = GetSchoolListSQL(hidGroupID.Value);
System.Text.StringBuilder sbSQL = new System.Text.StringBuilder();
sbSQL.Append("update port_autoimportholdingtank2 set PortfolioID=a.PortfolioID from Portfolio a WITH (NOLOCK) join port_autoimportholdingtank2 b WITH (NOLOCK) on b.StudentID=a.Username and a.SchoolID in " + strSchoolGroupList);
// Disabled error for usernames in file but not in group
//sbSQL.Append("update Port_UsernameReplaceGroup set ErrorMsg='Username does not exist in group' where PortfolioID is null");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username cannot be the same as password' where StudentID=PassWord");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination exists in the Portfolio table' from Portfolio a WITH (NOLOCK) join port_autoimportholdingtank2 b WITH (NOLOCK) on a.Username=b.StudentID and a.Password=b.Password and (a.PortfolioID<>b.PortfolioID OR b.PortfolioID IS NULL)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination already exists in Port_Parent_KY table' from Port_Parent_KY a WITH (NOLOCK) join port_autoimportholdingtank2 b WITH (NOLOCK) on a.Username=b.StudentID and a.Password=b.Password");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination already exists in Userinfo table' from Userinfo a WITH (NOLOCK) join port_autoimportholdingtank2 b WITH (NOLOCK) on a.Username=b.StudentID and a.Password=b.Password");
//sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='New username would create a username conflict within the school' from Portfolio a join port_autoimportholdingtank2 b on a.Username=b.newUserName and a.SchoolID=b.SchoolID and a.PortfolioID<>b.PortfolioID");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username appears twice in input file' where StudentID in (Select StudentID from port_autoimportholdingtank2 WITH (NOLOCK) group by StudentID having count(StudentID) > 1)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid Gender' where Gender not in ('M','F')");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid Grade' where Grade not in (SELECT gradenumber FROM dbo.GradeNumberLookup)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid School Codes' where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Duplicate Username in File' where StudentID in (Select StudentID from port_autoimportholdingtank2 WITH (NOLOCK) group by StudentID having count(StudentID) > 1)");
DataAccess.ExecuteDb(sbSQL.ToString());
sbSQL.Remove(0, sbSQL.Length);
// sbSQL = new System.Text.StringBuilder();
//System.Text.StringBuilder sbSQL = new System.Text.StringBuilder();
if (hidImportType.Value == "4")
{
//Changed Grade
sbSQL.Append("select count(h.RecordID) from Port_AutoImportHoldingtank2 h WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on h.PortfolioID=p.PortfolioID where h.Grade<>p.GradeNumber");
//Changed School
sbSQL.Append(";select count(h.RecordID) from Port_AutoImportHoldingTank2 h WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on h.PortfolioID=p.PortfolioID where h.SchoolIDFromCode<>p.SchoolID");
//Invalid Grade
sbSQL.Append(";select count(RecordID) from Port_AutoIMportHoldingTank2 WITH (NOLOCK) where Grade not in (SELECT gradenumber FROM dbo.GradeNumberLookup)");
//Invalid Gender
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 WITH (NOLOCK) where Gender not in ('M','F')");
//Invalid SchoolIDs
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 WITH (NOLOCK) where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
// Username appears more then once in file
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 WITH (NOLOCK) where ErrorMsg='Duplicate username in File' ");
// Username appears more than once in Portfolio table for group
sbSQL.Append(";Select count(Username) from Portfolio WITH (NOLOCK) where SchoolID IN " + strSchoolGroupList + " group by Username having count(Username) > 1 ");
sbSQL.Append(";Select count(StudentID) from port_autoimportholdingtank2 WITH (NOLOCK) where ErrorMsg is null and SchoolIDFromCode in " + strSchoolGroupList + " and PortfolioID is null");
sbSQL.Append(";Select count(p.PortfolioID) from Portfolio p WITH (NOLOCK) join Userinfo u WITH (NOLOCK) on p.SchoolID=u.SchoolID where p.Active=1 and u.CPSystemNameID=" + hidGroupID.Value + " and p.Username not in (Select StudentID from Port_AutoImportHoldingTank2 WITH (NOLOCK) )");
sbSQL.Append(";Select count(RecordID) from Port_AutoImportHoldingTank2 WITH (NOLOCK) where ErrorMsg='Username/Password combination exists in the Portfolio table'");
DataTable[] dtsStats = DataAccess.GetDataTables(sbSQL.ToString());
lblStudentsChangedGrades.Text = (dtsStats[0].Rows.Count > 0) ? dtsStats[0].Rows[0][0].ToString() : "0";
lblStudentsChangedSchools.Text = (dtsStats[1].Rows.Count > 0) ? dtsStats[1].Rows[0][0].ToString() : "0";
lblStudentsInvalidGrades.Text = (dtsStats[2].Rows.Count > 0) ? dtsStats[2].Rows[0][0].ToString() : "0";
lblStudentsInvalidGender.Text = (dtsStats[3].Rows.Count > 0) ? dtsStats[3].Rows[0][0].ToString() : "0";
lblStudentsInvalidSchool.Text = (dtsStats[4].Rows.Count > 0) ? dtsStats[4].Rows[0][0].ToString() : "0";
lblDuplicateUsernames.Text = (dtsStats[6].Rows.Count > 0) ? dtsStats[6].Rows.Count.ToString() : "0";
lblStudentsQuarantined.Text = (dtsStats[5].Rows.Count > 0) ? dtsStats[5].Rows[0][0].ToString() : "0";
lblStudentsAdded.Text = dtsStats[7].Rows[0][0].ToString();
lblStudentsDeactivated.Text = dtsStats[8].Rows[0][0].ToString();
lblUPConflicts.Text = dtsStats[9].Rows[0][0].ToString();
}
else if (hidImportType.Value == "5")
{
//Invalid Grade
sbSQL.Append("select count(RecordID) from Port_AutoIMportHoldingTank2 where Grade not in (5,6,7,8,9,10,11,12)");
//Invalid Gender
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 where Gender not in ('M','F')");
//Invalid SchoolIDs
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
// Username appears more then once in file
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 where ErrorMsg='Duplicate username in File'");
// Username appears more than once in Portfolio table for group
sbSQL.Append(";Select count(Username) from Portfolio WITH (NOLOCK) where SchoolID IN " + strSchoolGroupList + " group by Username having count(Username) > 1 ");
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 WITH (NOLOCK) where SchoolIDFromCode in " + strSchoolGroupList + " and PortfolioID is null and ErrorMsg is null");
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 WITH (NOLOCK) where PortfolioID is not null");
sbSQL.Append(";Update Port_AutoImportHoldingTank2 set ErrorMsg='Insert WITH (NOLOCK) Would Create Duplicate' where PortfolioID is not null");
DataTable[] dtsStats = DataAccess.GetDataTables(sbSQL.ToString());
lblStudentsInvalidGrades.Text = (dtsStats[0].Rows.Count > 0) ? dtsStats[0].Rows[0][0].ToString() : "0";
lblStudentsInvalidGender.Text = (dtsStats[1].Rows.Count > 0) ? dtsStats[1].Rows[0][0].ToString() : "0";
lblStudentsInvalidSchool.Text = (dtsStats[2].Rows.Count > 0) ? dtsStats[2].Rows[0][0].ToString() : "0";
lblDuplicateUsernames.Text = (dtsStats[4].Rows.Count > 0) ? dtsStats[4].Rows.Count.ToString() : "0";
lblStudentsQuarantined.Text = (dtsStats[3].Rows.Count > 0) ? dtsStats[3].Rows[0][0].ToString() : "0";
lblStudentsAdded.Text = dtsStats[5].Rows[0][0].ToString();
if (Convert.ToInt32(dtsStats[6].Rows[0][0]) > 0)
{
hlImport.Visible = false;
lblDisabled.Visible = true;
}
trInsertOnly.Visible = true;
lblCreatedDupes.Text = dtsStats[6].Rows[0][0].ToString();
}
if (Convert.ToInt32(lblDuplicateUsernames.Text) > 0)
{
hlImport.Visible = false;
lblDisabled.Visible = true;
}
}
pnlValidationStats.Visible = true;
}
else
{
string strOverride = "";
if (Strings.GetFormString("rdIncludeEmails") == "1")
strOverride = Strings.GetFormString("rdOverrideEmails");
lblEmailChoices.Text = GetEmailOptionsText(Strings.GetFormString("rdIncludeEmails"), strOverride);
hidIncEmails.Value = Strings.GetFormString("rdIncludeEmails");
hidOverwrite.Value = strOverride;
}
}
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
GridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridView1);
frm.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/*
public override void VerifyRenderingInServerForm(Control control)
{
}
* */
private void export2Excel(String sFilename)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", sFilename));
Response.Charset = "UTF-8";
Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
//bind lại gv
GridParent.AllowPaging = false;
napGridParent();
HtmlForm frm = new HtmlForm();
GridParent.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(GridParent);
frm.RenderControl(htmlWrite);
Response.Write("<table cellSpacing='0' cellPadding='0' width='100%' align='center' border='1'");
Response.Write(stringWrite.ToString());
Response.Write("</table>");
Response.End();
}
protected void btnExport_Click(object sender, EventArgs e)
{
//try
//{
// ChangeControlsToValue(GvFlightsReports);
// GvFlightsReports.Columns[13].Visible = false;
// Response.ClearContent();
// Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
// Response.ContentType = "application/excel";
// StringWriter sWriter = new StringWriter();
// HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
// HtmlForm hForm = new HtmlForm();
// GvFlightsReports.Parent.Controls.Add(hForm);
// hForm.Attributes["runat"] = "server";
// hForm.Controls.Add(GvFlightsReports);
// hForm.RenderControl(hTextWriter);
// StringBuilder sBuilder = new StringBuilder();
// sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
// sBuilder.Append(sWriter + "</body></html>");
// Response.Write(sBuilder.ToString());
// Response.End();
// GvFlightsReports.Columns[13].Visible = true;
//}
//catch (Exception ex)
//{
// //lblMsg.InnerHtml = ex.Message;
// throw ex;
//}
if (ddlserviceName.SelectedValue == "DomesticFlights")
{
try
{
ChangeControlsToValue(GvFlightsReports);
GvFlightsReports.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
GvFlightsReports.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(GvFlightsReports);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
GvFlightsReports.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
//ds=objbal.
}
else
if (ddlserviceName.SelectedValue == "InterNationalFlights")
{
try
{
ChangeControlsToValue(GvFlightsReports);
GvFlightsReports.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
GvFlightsReports.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(GvFlightsReports);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
GvFlightsReports.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
else
if (ddlserviceName.SelectedValue == "Hotels")
{
try
{
ChangeControlsToValue(GridView1);
GridView1.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
GridView1.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(GridView1);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
GridView1.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
else
if (ddlserviceName.SelectedValue == "Bus")
{
try
{
ChangeControlsToValue(gvBookings);
gvBookings.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
gvBookings.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(gvBookings);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
gvBookings.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
else
if (ddlserviceName.SelectedValue == "Recharge")
{
try
{
ChangeControlsToValue(gvMobile);
//gvMobile.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
gvMobile.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(gvMobile);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
gvMobile.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
else if (ddlserviceName.SelectedValue == "ALL")
{
try
{
ChangeControlsToValue(gdAllservicesreports);
// gdAllservicesreports.Columns[13].Visible = false;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Tickets.xls");
Response.ContentType = "application/excel";
StringWriter sWriter = new StringWriter();
HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
HtmlForm hForm = new HtmlForm();
gdAllservicesreports.Parent.Controls.Add(hForm);
hForm.Attributes["runat"] = "server";
hForm.Controls.Add(gdAllservicesreports);
hForm.RenderControl(hTextWriter);
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"> <head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=windows-1252\"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head> <body>");
sBuilder.Append(sWriter + "</body></html>");
Response.Write(sBuilder.ToString());
Response.End();
gdAllservicesreports.Columns[13].Visible = true;
}
catch (Exception ex)
{
//lblMsg.InnerHtml = ex.Message;
throw ex;
}
}
}
protected void BtnDownloadAttendanceAsExcel_Click(object sender, EventArgs e)
{
BtnGetAttendance_Click(sender, e);
LblSectionGroup1.Text = LblSectionGroup.Text;
LblSectionGroup2.Text = DDLSectionGroup.SelectedItem.ToString();
LblFromDate.Text = TxtBxFromDate.Text;
LblToDate.Text = TxtBxToDate.Text;
LblSubjectName.Text = DDLSubjects.SelectedItem.Text;
sql = "SELECT FacultyName from Faculty WHERE FacultyID='" + int.Parse(Session["FacultyID"].ToString()) + "'";
c = new Connect(sql);
LblFacultyName.Text = c.ds.Tables[0].Rows[0]["FacultyName"].ToString();
string name = DDLSectionGroup.SelectedItem.ToString().Replace(" ", "") + ".xls";
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=" + name;
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter stw = new StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(ListHeader);
if (GridView1.Visible == true)
form.Controls.Add(GridView1);
if (GridView2.Visible == true)
{
foreach (GridViewRow row in GridView2.Rows)
{
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView1.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView1.RowStyle.BackColor;
}
cell.CssClass = "textmode";
List<Control> controls = new List<Control>();
//Add controls to be removed to Generic List
foreach (Control control in cell.Controls)
{
controls.Add(control);
}
//Loop through the controls to be removed and replace then with Literal
foreach (Control control in controls)
{
switch (control.GetType().Name)
{
case "Label":
cell.Controls.Add(new Literal { Text = (control as Label).Text });
break;
case "TextBox":
cell.Controls.Add(new Literal { Text = (control as TextBox).Text });
break;
case "LinkButton":
cell.Controls.Add(new Literal { Text = (control as LinkButton).Text });
break;
case "CheckBox":
cell.Controls.Add(new Literal { Text = (control as CheckBox).Text });
break;
case "RadioButton":
cell.Controls.Add(new Literal { Text = (control as RadioButton).Text });
break;
}
cell.Controls.Remove(control);
}
}
}
form.Controls.Add(GridView2);
} this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
Server.ScriptTimeout = 1000000;
if (!IsPostBack)
{
if (Strings.GetFormString("hidExportType").Length > 0)
{
#region export file
Response.Write("Export the file.");
string strExportType = Strings.GetFormString("hidExportType");
string strExportSQL = GetExportSQL(strExportType);
DataTable dtExport = DataAccess.GetDataTable(strExportSQL);
gvExport.DataSource = dtExport;
gvExport.DataBind();
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Errors.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
HtmlForm newForm = new HtmlForm();
this.Controls.Add(newForm);
newForm.Controls.Add(gvExport);
newForm.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
this.Dispose();
#endregion
}
else
{
string strGroupID = Strings.GetQueryString("G");
GroupInfo.GroupID = strGroupID;
hidGroupID.Value = strGroupID;
hidImportType.Value = Strings.GetQueryString("T");
}
}
else
{
GroupInfo.GroupID = hidGroupID.Value;
pnlEmailChoice.Visible = true;
pnlEmailOptions.Visible = false;
if (hidImportConfirmed.Value == "1")
{
// !!! Intercept here for scheduled executions
System.Text.StringBuilder sbScheduleSQL = new System.Text.StringBuilder();
sbScheduleSQL.Append(@"INSERT dbo.Port_AutoImportScheduled ( ExecutionId , GroupId , SchoolList ,
IncludeEmails , hidUsernamesValue ,isCcSpark , PackageId ,DateValidated, FileName, OverwriteEmails ) VALUES ( " + hidExecutionID.Value + @" ,
" + hidGroupID.Value + @" , '" + GetSchoolListSQL(hidGroupID.Value) + @"' , " + hidIncEmails.Value + @" , " + hidUsernames.Value + @" ,
" + hidSpark.Value + @" , " + hidImportType.Value + @" , GetDate(), '" + hidFileName.Value + "','" + hidOverwrite.Value + "' )");
//
DataAccess.ExecuteDb(sbScheduleSQL.ToString());
Response.Write("The import has been successfully scheduled to run.<br /><br />");
Response.Write("<a href='/admin/autoimport/ImportActionMain.aspx'>Schedule Another</a>");
Response.End();
strSchoolGroupList = GetSchoolListSQL(hidGroupID.Value);
System.Text.StringBuilder sbInsertSQL = new System.Text.StringBuilder();
// do the import
if (hidImportType.Value == "5")
{
// Insert new Portfolios
sbInsertSQL.Append(GetInsertSQL(rdIncludeEmails1.Checked, hidUsernames.Value != "0", hidSpark.Value));
sbInsertSQL.Append(";Update Port_AutoImportExecutions set ExecutionDate=GetDate() where ExecutionID=" + hidExecutionID.Value);
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Added'," + lblStudentsAdded.Text + "," + hidExecutionID.Value + ")");
}
else if (hidImportType.Value == "4")
{
// deactivate existing portfolios that have duplicate rows in the imoprt file
sbInsertSQL.Append("update Portfolio set Active=0 from Port_AutoImportHoldingTank2 a ");
sbInsertSQL.Append("join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where ErrorMsg='Duplicate Username in File'");
DataAccess.ExecuteDb(sbInsertSQL.ToString());
// sbInsertSQL.Clear() was giving an error on Web3rdParty (old version of .net)?
sbInsertSQL.Remove(0,sbInsertSQL.Length);
string strRowSQL = @"UPDATE dbo.Port_AutoImportHoldingTank2
SET NeedsUpdate=1 FROM dbo.Portfolio p JOIN dbo.Port_AutoImportHoldingTank2 d ON p.PortfolioID = d.PortfolioID AND d.ErrorMsg IS NULL
JOIN dbo.UserInfo u on p.SchoolID=u.SchoolID and u.IsDemo=0
WHERE p.EmailAddress<>d.Email OR p.Active=0 OR p.GradeNumber<>d.Grade OR p.SchoolID<>d.SchoolIDFromCode ";
if (hidIncEmails.Value == "1" && hidOverwrite.Value == "1")
strRowSQL += " OR p.EmailAddress<>d.Email";
if (hidUsernames.Value != "0")
strRowSQL += " OR p.StudentId<>d.StudentIDText";
DataAccess.ExecuteDb(strRowSQL);
DataTable dtNeedsUpdate = DataAccess.GetDataTable("SELECT PortfolioID from Port_AutoImportHoldingTank2 where NeedsUpdate=1");
if (hidIncEmails.Value == "1" && hidOverwrite.Value == "1")
{
if (hidUsernames.Value != "0")
{
for (int c = 0; c < dtNeedsUpdate.Rows.Count; c++ )
{
string strUpdateSQL = "update Portfolio set EmailAddress= a.Email, Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword, ";
strUpdateSQL += "StudentID=a.StudentIDText from Port_AutoImportHoldingTankView a WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where p.PortfolioID=" + dtNeedsUpdate.Rows[c]["PortfolioID"];
DataAccess.ExecuteDb(strUpdateSQL);
}
}
else
{
// Include & Override emails
for (int c = 0; c < dtNeedsUpdate.Rows.Count; c++)
{
string strUpdateSQL = "update Portfolio set EmailAddress= a.Email, Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword ";
strUpdateSQL += "from Port_AutoImportHoldingTankView a WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where p.PortfolioID=" + dtNeedsUpdate.Rows[c]["PortfolioID"];
DataAccess.ExecuteDb(strUpdateSQL);
}
}
}
else
{
if (hidUsernames.Value != "0")
{
for (int c = 0; c < dtNeedsUpdate.Rows.Count; c++)
{
string strUpdateSQL = "update Portfolio set Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword, ";
strUpdateSQL += " StudentID=a.StudentIDTextfrom Port_AutoImportHoldingTankView a WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where p.PortfolioID=" + dtNeedsUpdate.Rows[c]["PortfolioID"];
DataAccess.ExecuteDb(strUpdateSQL);
}
}
else
{
// Don't include emails in update
for (int c = 0; c < dtNeedsUpdate.Rows.Count; c++)
{
string strUpdateSQL = "update Portfolio set Active=1,GradeNumber = a.Grade, Grade='Grade ' + cast(a.Grade as varchar(3)), SchoolID=a.SchoolIDFromCode, SchoolUsername=a.SchoolUserName, SchoolPassword=a.SchoolPassword ";
strUpdateSQL += "from Port_AutoImportHoldingTankView a WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on a.PortfolioID=p.PortfolioID where p.PortfolioID=" + dtNeedsUpdate.Rows[c]["PortfolioID"];
DataAccess.ExecuteDb(strUpdateSQL);
}
}
}
// WARNING: This step has the potential to turn off thousands of portfolios!
// Deactivate Portfolios that aren't in the import file
sbInsertSQL.Append(";update Portfolio set Active=0 where SchoolID in " + strSchoolGroupList + " and PortfolioID not in ");
sbInsertSQL.Append(" (select PortfolioID from Port_AutoImportHoldingTank2 where PortfolioID is not null);");
DataAccess.ExecuteDb(sbInsertSQL.ToString());
sbInsertSQL.Remove(0,sbInsertSQL.Length);
// Insert new Portfolios
sbInsertSQL.Append(GetInsertSQL(hidIncEmails.Value == "1", hidUsernames.Value != "0", hidSpark.Value));
sbInsertSQL.Append(";Update Port_AutoImportExecutions set ExecutionDate=GetDate() where ExecutionID=" + hidExecutionID.Value);
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Added'," + lblStudentsAdded.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Deactivated'," + lblStudentsDeactivated.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Changed Grade'," + lblStudentsChangedGrades.Text + "," + hidExecutionID.Value + ")");
sbInsertSQL.Append(";Insert Port_AutoImportStats (StatText,StatNumber,ExecutionID) VALUES ('Portfolios Changed School'," + lblStudentsChangedSchools.Text + "," + hidExecutionID.Value + ")");
}
//Response.Write(sbInsertSQL.ToString());
SqlConnection insertConnection = new SqlConnection(ConfigurationManager.AppSettings["strConLocal"]);
SqlCommand insertCommand = new SqlCommand(sbInsertSQL.ToString(), insertConnection);
insertCommand.CommandTimeout = 24000;
insertConnection.Open();
insertCommand.ExecuteNonQuery();
insertConnection.Close();
insertCommand = null;
insertConnection = null;
pnlEmailChoice.Visible = false;
pnlExport.Visible = false;
pnlEmailOptions.Visible = false;
pnlValidationStats.Visible = true;
pnlErrorsIssues.Visible = false;
trFinished.Visible = true;
}
else
{
if (fuFile.FileName.Length > 0)
{
string strFile = fuFile.FileName;
string strPath = "//CC-SRV-01/schoolusername/" + strFile;
hidFileName.Value = strFile;
DataAccess.ExecuteDb("Truncate table Port_AutoImportHoldingTank2");
fuFile.SaveAs(strPath);
// Get the password type!!!
string strPwdType = DataAccess.GetValue("SELECT Passwordtype FROM dbo.CP_SystemName WHERE SystemNameID=" + hidGroupID.Value).ToString();
WebClient client = new WebClient();
string strSuccess = client.DownloadString("http://172.16.10.19/admin/AutoImportStudentMain.aspx?G=" + strPwdType + "&E=" + hidIncEmails.Value + "&F=" + strFile + "&U=" + hidUsernames.Value);
// Don't delete the file anymore because it needs to be there for importing later on.
//System.IO.File.Delete(strPath);
if (strSuccess == "1")
{
// Update errors, stats, validate
pnlEmailChoice.Visible = false;
DataTable dtGroupSchools = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("Select SchoolID from UserInfo where CPSystemNameID=" + hidGroupID.Value);
string strPrefix = CareerCruisingWeb.CCLib.Common.DataAccess.GetValue("Select UsernamePrefix from CP_SystemName where SystemNameID=" + hidGroupID.Value).ToString();
string strBeginSQL = "Update port_autoimportholdingtank2 set StudentID=Replace(StudentID,'" + strPrefix + "','');Update port_autoimportholdingtank2 set StudentID='" + strPrefix + "' + StudentID;";
strBeginSQL += "update Port_AutoImportHoldingTank2 set SchoolIDFromCode = u.SchoolID from Userinfo u join Port_AutoImportHoldingTank2 p on p.AIExternalCode=u.AutoImportExternalCode and u.CPSystemNameID=" + hidGroupID.Value + ";Insert Port_AutoImportExecutions (PackageID, GroupID) Values (" + hidImportType.Value + " , " + hidGroupID.Value + ");select @@identity";
int intExecutionID = CareerCruisingWeb.CCLib.Common.DataAccess.ExecuteDbWithIntResult(strBeginSQL);
hidExecutionID.Value = intExecutionID.ToString();
if (dtGroupSchools.Rows.Count > 0)
{
strSchoolGroupList = GetSchoolListSQL(hidGroupID.Value);
System.Text.StringBuilder sbSQL = new System.Text.StringBuilder();
sbSQL.Append("update port_autoimportholdingtank2 set PortfolioID=a.PortfolioID from Portfolio a WITH (NOLOCK) join port_autoimportholdingtank2 b on b.StudentID=a.Username and a.SchoolID in " + strSchoolGroupList);
// Disabled error for usernames in file but not in group
//sbSQL.Append("update Port_UsernameReplaceGroup set ErrorMsg='Username does not exist in group' where PortfolioID is null");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username cannot be the same as password' where StudentID=PassWord");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination exists in the Portfolio table' from Portfolio a WITH (NOLOCK) join port_autoimportholdingtank2 b on a.Username=b.StudentID and a.Password=b.Password and (a.PortfolioID<>b.PortfolioID OR b.PortfolioID is null)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination already exists in Port_Parent_KY table' from Port_Parent_KY a join port_autoimportholdingtank2 b on a.Username=b.StudentID and a.Password=b.Password");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username/Password combination already exists in Userinfo table' from Userinfo a WITH (NOLOCK) join port_autoimportholdingtank2 b on a.Username=b.StudentID and a.Password=b.Password");
//sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='New username would create a username conflict within the school' from Portfolio a join port_autoimportholdingtank2 b on a.Username=b.newUserName and a.SchoolID=b.SchoolID and a.PortfolioID<>b.PortfolioID");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Username appears twice in input file' where StudentID in (Select StudentID from port_autoimportholdingtank2 group by StudentID having count(StudentID) > 1)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid Gender' where Gender not in ('M','F')");
if (hidSpark.Value == "1")
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid Grade' where Grade not in (0,1,2,3,4,5)");
else
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid Grade' where Grade not in (5,6,7,8,9,10,11,12,70)");
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Invalid School Codes' where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
sbSQL.Append(";update port_autoimportholdingtank2 set ErrorMsg='Duplicate Username in File' where StudentID in (Select StudentID from port_autoimportholdingtank2 group by StudentID having count(StudentID) > 1)");
DataAccess.ExecuteDb(sbSQL.ToString());
sbSQL.Remove(0, sbSQL.Length);
// sbSQL = new System.Text.StringBuilder();
//System.Text.StringBuilder sbSQL = new System.Text.StringBuilder();
if (hidImportType.Value == "4")
{
//Changed Grade
sbSQL.Append("select count(h.RecordID) from Port_AutoImportHoldingtank2 h WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on h.PortfolioID=p.PortfolioID where h.Grade<>p.GradeNumber");
//Changed School
sbSQL.Append(";select count(h.RecordID) from Port_AutoImportHoldingTank2 h WITH (NOLOCK) join Portfolio p WITH (NOLOCK) on h.PortfolioID=p.PortfolioID where h.SchoolIDFromCode<>p.SchoolID");
//Invalid Grade
sbSQL.Append(";select count(RecordID) from Port_AutoIMportHoldingTank2 WITH (NOLOCK) where Grade not in (5,6,7,8,9,10,11,12)");
//Invalid Gender
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 WITH (NOLOCK) where Gender not in ('M','F')");
//Invalid SchoolIDs
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 WITH (NOLOCK) where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
// Username appears more then once in file
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 WITH (NOLOCK) where ErrorMsg='Duplicate username in File' ");
// Username appears more than once in Portfolio table for group
sbSQL.Append(";Select count(Username) from Portfolio WITH (NOLOCK) where SchoolID IN " + strSchoolGroupList + " group by Username having count(Username) > 1 ");
sbSQL.Append(";Select count(StudentID) from port_autoimportholdingtank2 WITH (NOLOCK) where ErrorMsg is null and SchoolIDFromCode in " + strSchoolGroupList + " and PortfolioID is null");
sbSQL.Append(";Select count(p.PortfolioID) from Portfolio p WITH (NOLOCK) join Userinfo u WITH (NOLOCK) on p.SchoolID=u.SchoolID where p.Active=1 and u.CPSystemNameID=" + hidGroupID.Value + " and p.Username not in (Select StudentID from Port_AutoImportHoldingTank2)");
DataTable[] dtsStats = DataAccess.GetDataTables(sbSQL.ToString());
lblStudentsChangedGrades.Text = (dtsStats[0].Rows.Count > 0) ? dtsStats[0].Rows[0][0].ToString() : "0";
lblStudentsChangedSchools.Text = (dtsStats[1].Rows.Count > 0) ? dtsStats[1].Rows[0][0].ToString() : "0";
lblStudentsInvalidGrades.Text = (dtsStats[2].Rows.Count > 0) ? dtsStats[2].Rows[0][0].ToString() : "0";
lblStudentsInvalidGender.Text = (dtsStats[3].Rows.Count > 0) ? dtsStats[3].Rows[0][0].ToString() : "0";
lblStudentsInvalidSchool.Text = (dtsStats[4].Rows.Count > 0) ? dtsStats[4].Rows[0][0].ToString() : "0";
lblDuplicateUsernames.Text = (dtsStats[6].Rows.Count > 0) ? dtsStats[6].Rows.Count.ToString() : "0";
lblStudentsQuarantined.Text = (dtsStats[5].Rows.Count > 0) ? dtsStats[5].Rows[0][0].ToString() : "0";
lblStudentsAdded.Text = dtsStats[7].Rows[0][0].ToString();
lblStudentsDeactivated.Text = dtsStats[8].Rows[0][0].ToString();
}
else if (hidImportType.Value == "5")
{
//Invalid Grade
sbSQL.Append("select count(RecordID) from Port_AutoIMportHoldingTank2 where Grade not in (5,6,7,8,9,10,11,12)");
//Invalid Gender
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 where Gender not in ('M','F')");
//Invalid SchoolIDs
sbSQL.Append(";select count(RecordID) from Port_AutoImportHoldingTank2 where SchoolIDFromCode is null or SchoolIDFromCode not in" + strSchoolGroupList);
// Username appears more then once in file
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 where ErrorMsg='Duplicate username in File'");
// Username appears more than once in Portfolio table for group
sbSQL.Append(";Select count(Username) from Portfolio WITH (NOLOCK) where SchoolID IN " + strSchoolGroupList + " group by Username having count(Username) > 1 ");
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 where SchoolIDFromCode in " + strSchoolGroupList + " and PortfolioID is null and ErrorMsg is null");
sbSQL.Append(";Select count(RecordID) from port_autoimportholdingtank2 where PortfolioID is not null");
sbSQL.Append(";Update Port_AutoImportHoldingTank2 set ErrorMsg='Insert Would Create Duplicate' where PortfolioID is not null");
DataTable[] dtsStats = DataAccess.GetDataTables(sbSQL.ToString());
lblStudentsInvalidGrades.Text = (dtsStats[0].Rows.Count > 0) ? dtsStats[0].Rows[0][0].ToString() : "0";
lblStudentsInvalidGender.Text = (dtsStats[1].Rows.Count > 0) ? dtsStats[1].Rows[0][0].ToString() : "0";
lblStudentsInvalidSchool.Text = (dtsStats[2].Rows.Count > 0) ? dtsStats[2].Rows[0][0].ToString() : "0";
lblDuplicateUsernames.Text = (dtsStats[4].Rows.Count > 0) ? dtsStats[4].Rows.Count.ToString() : "0";
lblStudentsQuarantined.Text = (dtsStats[3].Rows.Count > 0) ? dtsStats[3].Rows[0][0].ToString() : "0";
lblStudentsAdded.Text = dtsStats[5].Rows[0][0].ToString();
if (Convert.ToInt32(dtsStats[6].Rows[0][0]) > 0)
{
hlImport.Visible = false;
lblDisabled.Visible = true;
}
trInsertOnly.Visible = true;
lblCreatedDupes.Text = dtsStats[6].Rows[0][0].ToString();
}
if (Convert.ToInt32(lblDuplicateUsernames.Text) > 0)
{
hlImport.Visible = false;
lblDisabled.Visible = true;
}
}
pnlValidationStats.Visible = true;
}
}
else
{
string strOverride = "";
if (Strings.GetFormString("rdIncludeEmails") == "1")
strOverride = Strings.GetFormString("rdOverrideEmails");
lblEmailChoices.Text = GetEmailOptionsText(Strings.GetFormString("rdIncludeEmails"), strOverride);
hidIncEmails.Value = Strings.GetFormString("rdIncludeEmails");
hidOverwrite.Value = strOverride;
hidUsernames.Value = CareerCruisingWeb.CCLib.Common.Strings.GetFormString("cbUsernameStudent");
hidSpark.Value = (cbSpark.Checked) ? "1" : "0";
lblUseAsIds.Text = GetStudentIDsText(CareerCruisingWeb.CCLib.Common.Strings.GetFormString("cbUsernameStudent"));
lblSpark.Text = (hidSpark.Value == "1") ? "Yes" : "No";
}
}
}
}
private void export2Excel(String sFilename)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", sFilename));
Response.Charset = "UTF-8";
Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
INVI.INVILibrary.INVIHelper.PrepareGridViewForExport(grvTinh);
HtmlForm frm = new HtmlForm();
grvTinh.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(grvTinh);
frm.RenderControl(htmlWrite);
Response.Write("<table cellSpacing='0' cellPadding='0' width='100%' align='center' border='1'");
Response.Write(stringWrite.ToString());
Response.Write("</table>");
Response.End();
}
