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);
}
/// Date Created: 05/Jan/2015
/// Created By: Josephine Monteza
/// (description) tag record to TblTag_Hotel
/// -------------------------------------------
private void TagSeafarer(string sIdBigint, string sTRId, string sBranch, string sRecLoc, string sE1Id, string sStatusOnOff)
{
string sUser = uoHiddenFieldUser.Value;
string sRole = uoHiddenFieldRole.Value;
string strLogDescription = "Tag Seafarer To Hotel Service Provider";
string strFunction = "TagSeafarer";
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
ManifestBLL MBLL = new ManifestBLL();
MBLL.TagToHotel(GlobalCode.Field2Long(sIdBigint), GlobalCode.Field2Long(sTRId), sRecLoc,
GlobalCode.Field2Long(sE1Id), sStatusOnOff, 0, GlobalCode.Field2Long(sBranch),
uoHiddenFieldUser.Value, strLogDescription, strFunction, Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), dateNow);
if (sBranch != "0")
{
BindHotelManifest(1);
}
}
/// <summary>
/// Date Created: 23/Apr/2014
/// Created By: Muhallidin G Wali
/// (description) cancel hotel booking and insert into a table (TblHotelTransactionOtherCancel)
/// ==========================================================
/// Date Modified: 24/Apr/2014
/// Modified By: Josephine Gad
/// (description) Add ClosePage to close this page and refresh the parent page
/// Change Session["UserName"].ToString() to uoHiddenFieldUser.Value
/// Add parameter fot Audit Trail
/// ==========================================================
/// </summary>
protected void btnSaveCancelHotel_Click(object sender, EventArgs e)
{
try
{
ManifestBLL bll = new ManifestBLL();
string strLogDescription = "Cancel Hotel in Primary Vendor";
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
bll.CancelHotelBooking(uoHiddenFieldTravelReq.Value, uoHiddenFieldUser.Value,
txtEmailTo.Text.ToString(), txtEmailCC.Text.ToString(), uoTextBoxConfirmedBy.Text.ToString(),
uoTextBoxComment.Text.ToString(), DateTime.Now, true, uoHiddenFieldRole.Value,
strLogDescription, "btnSaveCancelHotel_Click",
Path.GetFileName(Request.UrlReferrer.AbsolutePath), CommonFunctions.GetDateTimeGMT(dateNow));
ClosePage();
}
catch (Exception ex)
{
AlertMessage(ex.Message.ToString());
}
}
