protected void btnReport_Click(object sender, EventArgs e)
{
string fileName = string.Empty;
FileUtil t = null;
CommonBLL cls = new CommonBLL();
DataTable dtExcel = new DataTable();
dtExcel = cls.GenerateExcel(ddlLine.SelectedValue, ddlVessel.SelectedValue, hdnReturn.Value, ddlLocation.SelectedValue, ddlVoyage.SelectedValue, txtVIANo.Text);
ExporttoExcel(dtExcel);
//switch (CommonBLL.GetTerminalType(Convert.ToInt32(ddlVoyage.SelectedValue), Convert.ToInt32(ddlVessel.SelectedValue), Convert.ToInt32(hdnReturn.Value)))
//{
// case "NSICT":
// {
// CommonBLL cls = new CommonBLL();
// try
// {
// //DateTime dt = Convert.ToDateTime(txtdtStock.Text.Trim());
// DataTable dtExcel = new DataTable();
// dtExcel = cls.GenerateExcel(ddlLine.SelectedValue, ddlVessel.SelectedValue, hdnReturn.Value, ddlLocation.SelectedValue, ddlVoyage.SelectedValue, txtVIANo.Text);
// ExporttoExcel(dtExcel);
// }
// catch (Exception ex)
// {
// }
// }
// break;
// case "JNPT":
// fileName = Server.MapPath("~/Download/ContainerList.txt");
// if (File.Exists(fileName))
// File.Delete(fileName);
// t = new FileUtil(Server.MapPath("~/FileTemplate/ContainerList.txt"), fileName);
// if (CommonBLL.GenerateText(fileName, Convert.ToInt32(ddlLine.SelectedValue), Convert.ToInt32(ddlVessel.SelectedValue), Convert.ToInt32(hdnReturn.Value), Convert.ToInt32(ddlLocation.SelectedValue), Convert.ToInt32(ddlVoyage.SelectedValue), Convert.ToInt32(txtVIANo.Text)))
// {
// t.Download(Response);
// }
// break;
// case "GTI":
// fileName = Server.MapPath("~/Download/ContainerList.txt");
// if (File.Exists(fileName))
// File.Delete(fileName);
// t = new FileUtil(Server.MapPath("~/FileTemplate/ContainerList.txt"), fileName);
// if (CommonBLL.GenerateText(fileName, Convert.ToInt32(ddlLine.SelectedValue), Convert.ToInt32(ddlVessel.SelectedValue), Convert.ToInt32(hdnReturn.Value), Convert.ToInt32(ddlLocation.SelectedValue), Convert.ToInt32(ddlVoyage.SelectedValue), Convert.ToInt32(txtVIANo.Text)))
// {
// t.Download(Response);
// }
// break;
// default:
// {
// CommonBLL cls = new CommonBLL();
// try
// {
// DataTable dtExcel = new DataTable();
// dtExcel = cls.GenerateExcel(ddlLine.SelectedValue, ddlVessel.SelectedValue, hdnReturn.Value, ddlLocation.SelectedValue, ddlVoyage.SelectedValue, txtVIANo.Text);
// ExporttoExcel(dtExcel);
// }
// catch (Exception ex)
// {
// }
// }
// break;
//}
}
