protected void uoLinkExport_Click(object sender, EventArgs e)
{
DataSet ds = ManifestBLL.getAllDataFiles(GlobalCode.Field2DateTime(Session["DateFrom"]), GlobalCode.Field2String(Session["UserName"]));
string FilePath = Server.MapPath("~/Extract/Manifest/");
string mDate = GlobalCode.Field2DateTime(Session["DateFrom"]).ToString(TravelMartVariable.DateTimeFormatFileExtension);
string sDate = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension);
string FileName = "Manifest_" + mDate + "_" + sDate + ".xls";
ds.Tables[0].TableName = "Same day Arrival Departure";
ds.Tables[1].TableName = "No Travel request";
int count = 2;
while (count < ds.Tables.Count)
{
ds.Tables[count].TableName = ds.Tables[count].Rows[0]["HotelName"].ToString();
count += 1;
}
string strFileName = FilePath + FileName;
if (File.Exists(strFileName))
{
File.Delete(strFileName);
}
Convert(ds, strFileName);
OpenExcelFile(FileName);
}
