/// <summary>
/// Save location
/// </summary>
private int SaveBooking()
{
Generic <PNK_Booking> genericBLL = new Generic <PNK_Booking>();
Generic2C <PNK_Booking, PNK_BookingDesc> generic2CBLL = new Generic2C <PNK_Booking, PNK_BookingDesc>();
PNK_Booking bookingObj = new PNK_Booking();
PNK_BookingDesc bookingObjVn = new PNK_BookingDesc();
PNK_BookingDesc bookingObjEn = new PNK_BookingDesc();
//if (this.productcategoryId == int.MinValue)
//{
//get data insert
bookingObj = this.GetDataObjectParent(bookingObj);
bookingObj.Ordering = genericBLL.getOrdering();
bookingObjVn = this.GetDataObjectChild(bookingObjVn, Constant.DB.LangId);
bookingObjEn = this.GetDataObjectChild(bookingObjEn, Constant.DB.LangId_En);
List <PNK_BookingDesc> lst = new List <PNK_BookingDesc>();
lst.Add(bookingObjVn);
lst.Add(bookingObjEn);
//excute
bookingId = generic2CBLL.Insert(bookingObj, lst);
return(bookingId);
}
/// <summary>
/// saveOrder
/// </summary>
private void SaveOrder()
{
foreach (RepeaterItem item in rptResult.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
HtmlInputButton btId = (HtmlInputButton)item.FindControl("btId");
PNK_Booking productCat = new PNK_Booking();
productCat.Id = DBConvert.ParseInt(btId.Value);
productCat = genericBLL.Load(productCat, new string[] { "Id" });
HtmlInputText txtOrder = (HtmlInputText)item.FindControl("txtOrder");
if (txtOrder != null)
{
try
{
productCat.Ordering = DBConvert.ParseInt(txtOrder.Value);
if (productCat.Ordering > 0)
{
genericBLL.Update(productCat, productCat, new string[] { "Id" });
}
}
catch { }
}
}
}
}
/// <summary>
/// Save location
/// </summary>
private int SaveBooking()
{
Generic <PNK_Booking> genericBLL = new Generic <PNK_Booking>();
Generic2C <PNK_Booking, PNK_BookingDesc> generic2CBLL = new Generic2C <PNK_Booking, PNK_BookingDesc>();
PNK_Booking objBooking = new PNK_Booking();
PNK_BookingDesc bookingObjVn = new PNK_BookingDesc();
PNK_BookingDesc bookingObjEn = new PNK_BookingDesc();
//if (this.productcategoryId == int.MinValue)
//{
//get data insert
objBooking = this.GetDataObjectParent(objBooking);
objBooking.Ordering = genericBLL.getOrdering();
bookingObjVn = this.GetDataObjectChild(bookingObjVn, Constant.DB.LangId);
bookingObjEn = this.GetDataObjectChild(bookingObjEn, Constant.DB.LangId_En);
List <PNK_BookingDesc> lst = new List <PNK_BookingDesc>();
lst.Add(bookingObjVn);
lst.Add(bookingObjEn);
//Giữ lại để chuyển qua form bookingresult
Session["objBooking"] = objBooking;
Session["lstBookingDesc"] = lst;
//excute
//bookingId = generic2CBLL.Insert(objBooking, lst);
//Send email đến KH
//if (bookingId != int.MinValue)
//{
// SendEmailTempate(objBooking);
//}
return(bookingId);
}
/// <summary>
/// get data for insert update
/// </summary>
/// <param name="userObj"></param>
/// <returns></returns>
private PNK_Booking GetDataObjectParent(PNK_Booking productcatObj)
{
//productcatObj.CategoryId = 1;
//productcatObj.Phone = this.txtPhone.Value;
productcatObj.Published = chkPublished.Checked ? "1" : "0";
productcatObj.UpdateDate = DateTime.Now;
return(productcatObj);
}
/// <summary>
/// get data for insert update
/// </summary>
/// <param name="userObj"></param>
/// <returns></returns>
private PNK_Booking GetDataObjectParent(PNK_Booking obj)
{
obj.ParentId = 1;
obj.FirstName = txtFirstName.Value.Trim();
obj.LastName = txtLastName.Value.Trim();
obj.PhoneNumber = txtPhoneNumber.Text.Trim();
obj.RequestTour = txtRequestTour.Value.Trim();
obj.ExpectedDepartureDate = txtExpectedDepartureDate.Value;
obj.NumberOfAduts = txtNumberAduts.Value.Trim();
obj.NumberOfChildren = txtNumberChild.Value.Trim();
obj.NumberOfInfant = txtNumberInfant.Value.Trim();
obj.Published = "1";
obj.Email = txtEmail.Text.Trim();
obj.RequestTour = txtRequestTour.Value.Trim();
obj.HotelType = drpHotel.Items[drpHotel.SelectedIndex].Text;
obj.ArrivalPort = drpArrival.Items[drpArrival.SelectedIndex].Text;
obj.RoomType = drpRoomType.Items[drpRoomType.SelectedIndex].Text;
obj.RoomOther = txtRoomOther.Value.Trim();
obj.BedType = drpBedType.Items[drpBedType.SelectedIndex].Text;
obj.BedOther = txtBedOther.Value.Trim();
obj.VisaOfNeed = rdVisaYes.Checked == true ? "Yes" : "No";
//obj.KnowThrough = drpKnow.Items[drpKnow.SelectedIndex].Text;
//obj.PaymentMethod = drpPayment.Items[drpPayment.SelectedIndex].Text;
obj.Distance = drpDistance.Items[drpDistance.SelectedIndex].Text;
obj.FlightArrivalNo = txtFlightArrivalNo.Text.Trim();
obj.FlightArrivaTime = txtFlightArrialTime.Text.Trim();
obj.FlightDepartureTime = txtFlightDepartureTime.Text.Trim();
obj.FlightArrivalDate = txtFlightArrivalDate.Text.Trim();
obj.FlightDepartureDate = txtFlightDepartureDate.Text.Trim();
obj.CustomerHeight = txtCustomerHeight.Text.Trim();
obj.HotelName = txtHotelName.Text.Trim();
obj.CustomerAge = txtCustomerAge.Text.Trim();
obj.HotelAddress = txtHotelAddress.Text.Trim();
obj.Country = drpCountry.Items[drpCountry.SelectedIndex].Text;
obj.City = hddDrpCityValue.Value;
obj.SpecialRequest = txtSpecialRequest.Text;
obj.PickUpLocation = txtPickUpLocation.Text;
obj.UpdateDate = DateTime.Now;
obj.PostDate = DateTime.Now;
obj.Total = hddPriceSumValue.Value;
obj.PaymentMethod = drpPaymentType.Items[drpPaymentType.SelectedIndex].Text;
return(obj);
}
/// <summary>
/// Save location
/// </summary>
private void SaveBookingCategory()
{
PNK_Booking productcatObj = new PNK_Booking();
PNK_BookingDesc productcatObjVn = new PNK_BookingDesc();
PNK_BookingDesc productcatObjEn = new PNK_BookingDesc();
if (this.productcategoryId == int.MinValue)
{
//get data insert
productcatObj = this.GetDataObjectParent(productcatObj);
productcatObj.PostDate = DateTime.Now;
productcatObj.Ordering = genericBLL.getOrdering();
productcatObjVn = this.GetDataObjectChild(productcatObjVn, Constant.DB.LangId);
productcatObjEn = this.GetDataObjectChild(productcatObjEn, Constant.DB.LangId_En);
List <PNK_BookingDesc> lst = new List <PNK_BookingDesc>();
lst.Add(productcatObjVn);
lst.Add(productcatObjEn);
//excute
this.productcategoryId = generic2CBLL.Insert(productcatObj, lst);
}
else
{
string[] fields = { "Id" };
productcatObj.Id = this.productcategoryId;
productcatObj = genericBLL.Load(productcatObj, fields);
//string publisheddOld = productcatObj.Published;
//get data update
productcatObj = this.GetDataObjectParent(productcatObj);
productcatObjVn = this.GetDataObjectChild(productcatObjVn, Constant.DB.LangId);
productcatObjEn = this.GetDataObjectChild(productcatObjEn, Constant.DB.LangId_En);
List <PNK_BookingDesc> lst = new List <PNK_BookingDesc>();
lst.Add(productcatObjVn);
lst.Add(productcatObjEn);
//excute
generic2CBLL.Update(productcatObj, lst, fields);
//neu ve Published oo thay doi thi chay ham ChangeWithTransaction de doi Published cac con va cac product
//if (publisheddOld != productcatObj.Published)
// PNK_Booking.ChangeWithTransaction(DBConvert.ParseString(this.productcategoryId), productcatObj.Published);
}
}
/// <summary>
/// get data for insert update
/// </summary>
/// <param name="userObj"></param>
/// <returns></returns>
private PNK_Booking GetDataObjectParent(PNK_Booking obj)
{
obj.ParentId = 1;
obj.FullName = txtFullName.Value.Trim();
obj.PhoneNumber = txtPhone.Value.Trim();
obj.RequestTour = drpService.Items[drpService.SelectedIndex].Text;
obj.ExpectedDepartureDate = drpConstructions.Items[drpConstructions.SelectedIndex].Text;
obj.NumberOfAduts = drpLocation.Items[drpLocation.SelectedIndex].Text;
obj.NumberOfChildren = txtArea.Value.Trim();
obj.Published = "1";
obj.Email = txtEmail.Value.Trim();
obj.HotelType = txtSubject.Value.Trim();
obj.ArrivalPort = txtMessage.Value.Trim();
//obj.RoomType = drpRoomType.Items[drpRoomType.SelectedIndex].Text;
//obj.RoomOther = txtRoomOther.Value.Trim();
//obj.BedType = drpBedType.Items[drpBedType.SelectedIndex].Text;
//obj.BedOther = txtBedOther.Value.Trim();
//obj.VisaOfNeed = rdVisaYes.Checked == true ? "Yes" : "No";
//obj.KnowThrough = drpKnow.Items[drpKnow.SelectedIndex].Text;
//obj.PaymentMethod = drpPayment.Items[drpPayment.SelectedIndex].Text;
//obj.Distance = drpDistance.Items[drpDistance.SelectedIndex].Text;
//obj.FlightArrivalNo = txtFlightArrivalNo.Text.Trim();
//obj.FlightArrivaTime = txtFlightArrialTime.Text.Trim();
//obj.FlightDepartureTime = txtFlightDepartureTime.Text.Trim();
//obj.FlightArrivalDate = txtFlightArrivalDate.Text.Trim();
//obj.FlightDepartureDate = txtFlightDepartureDate.Text.Trim();
//obj.CustomerHeight = txtCustomerHeight.Text.Trim();
//obj.HotelName = txtHotelName.Text.Trim();
//obj.CustomerAge = txtCustomerAge.Text.Trim();
//obj.HotelAddress = txtHotelAddress.Text.Trim();
obj.UpdateDate = DateTime.Now;
obj.PostDate = DateTime.Now;
return(obj);
}
private int SaveBooking(string paymentStatus)
{
//Get obj từ form booking
PNK_Booking objBooking = Session["objBooking"] != null ? (PNK_Booking)Session["objBooking"] : null;
objBooking.PaymentStatus = paymentStatus != string.Empty ? paymentStatus : string.Empty;
List <PNK_BookingDesc> lstBookingDesc = Session["objBooking"] != null ? (List <PNK_BookingDesc>)Session["lstBookingDesc"] : null;
//excute
Generic2C <PNK_Booking, PNK_BookingDesc> generic2CBLL = new Generic2C <PNK_Booking, PNK_BookingDesc>();
bookingId = generic2CBLL.Insert(objBooking, lstBookingDesc);
//Send email đến KH
if (bookingId != int.MinValue)
{
SendEmailTempate(objBooking);
}
return(bookingId);
}
/// <summary>
/// ItemDataBound
/// </summary>
protected void rptResult_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string img, alt, publishedTask;
HtmlTableRow tr = (HtmlTableRow)e.Item.FindControl("trList");
HtmlInputText txt = null;
if (e.Item.ItemIndex % 2 == 0)
{
tr.Attributes.Add("class", "even");
}
else
{
tr.Attributes.Add("class", "old");
}
try
{
PNK_Booking data = (PNK_Booking)e.Item.DataItem;
//Role
Literal ltr = null;
ltr = (Literal)e.Item.FindControl("ltrchk");
ltr.Text = string.Format(@"<INPUT class='txt' TYPE='checkbox' ID='cb{0}' NAME='cid[]' value='{1}' onclick='isChecked(this.checked);' >",
e.Item.ItemIndex, data.Id);
//ltrNewsCategory
ltr = (Literal)e.Item.FindControl("ltrNewsCategory");
//image
if (data.Published == "1")
{
img = "tick.png";
alt = LocalizationUtility.GetText(ltrAdminPublish.Text);
publishedTask = "unpublish";
}
else
{
img = "publish_x.png";
alt = LocalizationUtility.GetText(ltrAdminPublish.Text);
publishedTask = "publish";
}
//Order
txt = (HtmlInputText)e.Item.FindControl("txtOrder");
txt.Value = DBConvert.ParseString(data.Ordering);
//Id
HtmlInputButton btId = (HtmlInputButton)e.Item.FindControl("btId");
btId.Value = DBConvert.ParseString(data.Id);
//set link
HyperLink hdflink = new HyperLink();
hdflink = (HyperLink)e.Item.FindControl("hdflink");
hdflink.NavigateUrl = template_path + LinkHelper.GetAdminLink("edit_booking", data.Id);
ImageButton imgctr = (ImageButton)e.Item.FindControl("btnPublish");
imgctr.ImageUrl = string.Format("/Admin/images/{0}", img);
imgctr.Attributes.Add("alt", alt);
HtmlTableCell btn = (HtmlTableCell)e.Item.FindControl("tdbtn");
btn.Attributes.Add("onclick", string.Format(" return listItemTask('cb{0}', '{1}')", e.Item.ItemIndex, publishedTask));
//Name
ltr = (Literal)e.Item.FindControl("ltrName");
ltr.Text = string.IsNullOrWhiteSpace(data.FirstName) || string.IsNullOrWhiteSpace(data.LastName) ? "[No name]" : string.Format("{0} {1}", data.FirstName, data.LastName);// data.FullName;
//Phone
ltr = (Literal)e.Item.FindControl("txtPhone");
ltr.Text = data.PhoneNumber;
}
catch { }
}
}
/// <summary>
/// Show location
/// </summary>
private void ShowProductcategory()
{
if (this.productcategoryId != int.MinValue)
{
PNK_Booking productcatObj = new PNK_Booking();
string[] fields = { "Id" };
productcatObj.Id = this.productcategoryId;
productcatObj = generic2CBLL.Load(productcatObj, fields, Constant.DB.LangId);
this.chkPublished.Checked = productcatObj.Published == "1" ? true : false;
txtFistName.Value = productcatObj.FirstName;
txtLastName.Value = productcatObj.LastName;
txtPhoneNumber.Value = productcatObj.PhoneNumber;
txtEmail.Value = productcatObj.Email;
txtRequestTour.Value = productcatObj.RequestTour;
txtExpectedDepartureDate.Value = productcatObj.ExpectedDepartureDate;
txtNumberOfAdults.Value = productcatObj.NumberOfAduts;
txtNumberOfChildren.Value = productcatObj.NumberOfChildren;
txtNumberOfInfant.Value = productcatObj.NumberOfInfant;
txtTypeOfHotels.Value = productcatObj.HotelType;
txtArrivalPort.Value = productcatObj.ArrivalPort;
txtRoomType.Value = productcatObj.RoomType;
txtOthersRoom.Value = productcatObj.RoomOther;
txtBedType.Value = productcatObj.BedType;
txtOtherBed.Value = productcatObj.BedOther;
txtNeedVisaService.Value = productcatObj.VisaOfNeed;
txtKnowThrought.Value = productcatObj.KnowThrough;
txtPaymentMethod.Value = productcatObj.PaymentMethod;
txtPaymentStatus.Value = productcatObj.PaymentStatus;
txtDistance.Value = productcatObj.Distance;
txtFlightArrivalNo.Text = productcatObj.FlightArrivalNo;
txtFlightArrialTime.Text = productcatObj.FlightArrivaTime;
txtFlightDepartureTime.Text = productcatObj.FlightDepartureTime;
txtFlightArrivalDate.Text = productcatObj.FlightArrivalDate;
txtFlightDepartureDate.Text = productcatObj.FlightDepartureDate;
txtCustomerHeight.Text = productcatObj.CustomerHeight;
txtHotelName.Text = productcatObj.HotelName;
txtCustomerAge.Text = productcatObj.CustomerAge;
txtHotelAddress.Text = productcatObj.HotelAddress;
txtPickUp.Value = productcatObj.PickUpLocation;
txtCity.Value = productcatObj.City;
txtCountry.Value = productcatObj.Country;
IList <PNK_BookingDesc> lst = genericDescBLL.GetAllBy(new PNK_BookingDesc(), string.Format(" where mainid = {0}", this.productcategoryId), null);
foreach (PNK_BookingDesc item in lst)
{
switch (item.LangId)
{
case 1:
//productcatObj.MainId = 1;
//productcatObj.LangId = Constant.DB.LangId;
//productcatObj.Name = SanitizeHtml.Sanitize(txtFullName.Value);
break;
case 2:
//productcatObj.MainId = 1;
//productcatObj.LangId = Constant.DB.LangId_En;
//productcatObj.Name = SanitizeHtml.Sanitize(txtFullName.Value);
break;
}
}
}
}
private void SendEmailTempate(PNK_Booking obj)
{
try
{
string companyName = string.Empty, companyEmail = string.Empty, companyPhone = string.Empty, companyAddress = string.Empty
, companyWebsite = string.Empty, companyFax = string.Empty;
ConfigurationBLL pcBll = new ConfigurationBLL();
IList <PNK_Configuration> lst = pcBll.GetList();
if (lst != null && lst.Count > 0)
{
foreach (PNK_Configuration item in lst)
{
if (item.Key_name == Constant.Configuration.config_company_name_vi)
{
companyName = item.Value_name;
}
if (item.Key_name == Constant.Configuration.email)
{
companyEmail = item.Value_name;
}
if (item.Key_name == Constant.Configuration.phone)
{
companyPhone = item.Value_name;
}
if (item.Key_name == Constant.Configuration.config_address_vi)
{
companyAddress = item.Value_name;
}
if (item.Key_name == Constant.Configuration.sitename)
{
companyWebsite = item.Value_name;
}
if (item.Key_name == Constant.Configuration.fax)
{
companyFax = item.Value_name;
}
}
}
string path = Request.PhysicalApplicationPath;
string strHtml = WebUtils.GetMailTemplate(Path.Combine(path, "TemplateMail/Booking.html"));
string body = string.Format(strHtml,
companyName, //0
obj.FirstName, //1
obj.LastName, //2
obj.Country, //3
obj.City, //4
obj.PhoneNumber, //5
obj.Email, //6
obj.PickUpLocation, //7
DateTime.Now, //8
obj.RequestTour, //9
obj.ExpectedDepartureDate, //10
obj.NumberOfAduts, //11
obj.NumberOfChildren, //12
obj.NumberOfInfant, //13
obj.Total, //14
obj.PaymentMethod, //15
companyAddress, //16
companyEmail, //17
companyWebsite, //18
companyPhone, //19
companyFax, //20
obj.PaymentStatus //21
);
WebUtils.SendEmail("Contact", obj.Email, string.Empty, body);
}
catch (Exception ex)
{
Write2Log.WriteLogs("BookingResutl", "SendEmailTempate", ex.Message);
}
}
private void SendEmailTempate(PNK_Booking obj)
{
string companyName = string.Empty, companyEmail = string.Empty, companyPhone = string.Empty;;
ConfigurationBLL pcBll = new ConfigurationBLL();
IList <PNK_Configuration> lst = pcBll.GetList();
if (lst != null && lst.Count > 0)
{
foreach (PNK_Configuration item in lst)
{
if (item.Key_name == Constant.Configuration.config_company_name_vi)
{
companyName = item.Value_name;
}
if (item.Key_name == Constant.Configuration.email)
{
companyEmail = item.Value_name;
}
if (item.Key_name == Constant.Configuration.phone)
{
companyPhone = item.Value_name;
}
}
}
string path = Request.PhysicalApplicationPath;
string strHtml = WebUtils.GetMailTemplate(Path.Combine(path, "TemplateMail/Booking.txt"));
string body = string.Format(strHtml,
companyName, //0
obj.FullName, //1
obj.Email, //2
obj.PhoneNumber, //3
obj.RequestTour, //4
obj.ExpectedDepartureDate, //5
obj.NumberOfAduts, //6
obj.NumberOfChildren, //7
obj.HotelType, //8
obj.RoomType, //9
obj.RoomOther, //10
obj.BedType, //11
obj.BedOther, //12
obj.ArrivalPort, //13
obj.VisaOfNeed, //14
obj.PaymentMethod, //15
obj.Distance, //16
obj.FlightArrivalNo, //17
obj.FlightArrivaTime, //18
obj.FlightArrivalDate, //19
obj.FlightDepartureTime, //20
obj.FlightDepartureDate, //21
obj.CustomerHeight, //22
obj.CustomerAge, //23
obj.HotelName, //24
obj.HotelAddress, //25
companyEmail, //26
companyPhone, //27
"fasfasf");
WebUtils.SendEmail("LienHe", string.Empty, string.Empty, body);
}