public void OnEvent(object sender, EventArgs e)
{
UpdatePanel owner = Owner;
if (owner != null && owner.UpdateMode != UpdatePanelUpdateMode.Always)
{
owner.Update();
}
}
protected void AddArrival(GridView gv, UpdatePanel uppanel)
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
TextBox txtFlightname = (TextBox)item.FindControl("txtFlightName");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtNoOfPassenger = (TextBox)item.FindControl("txtNoOfPassenger");
TextBox txtdate = (TextBox)item.FindControl("txtFlightDate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Flightname");
dt.Columns.Add("Time");
dt.Columns.Add("NoOfPassenger");
dt.Columns.Add("Date");
}
DataRow dr = dt.NewRow();
dr["Flightname"] = txtFlightname.Text;
dr["Time"] = txttime.SelectedDate;
dr["NoOfPassenger"] = txtNoOfPassenger.Text;
dr["Date"] = txtdate.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Flightname");
dt.Columns.Add("Time");
dt.Columns.Add("NoOfPassenger");
dt.Columns.Add("Date");
}
DataRow dr = dt.NewRow();
dr["Flightname"] = "";
dr["Time"] = "";
dr["NoOfPassenger"] = "";
dr["Date"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
TextBox txtFlightname = (TextBox)item.FindControl("txtFlightName");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtNoOfPassenger = (TextBox)item.FindControl("txtNoOfPassenger");
TextBox txtdate = (TextBox)item.FindControl("txtFlightDate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
txtFlightname.Text = dt.Rows[itm]["Flightname"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
txtNoOfPassenger.Text = dt.Rows[itm]["NoOfPassenger"].ToString();
txtdate.Text = dt.Rows[itm]["Date"].ToString();
}
}
}
uppanel.Update();
}
protected void unitNoChanged(GridView gv, UpdatePanel uppanel, int rowIndex)
{
try
{
foreach (GridViewRow item in gv.Rows)
{
int Index = item.DataItemIndex;
if (Index == rowIndex)
{
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
TextBox txtUnitNo = (TextBox)item.FindControl("txtUnitNo");
TextBox txtAPP = (TextBox)item.FindControl("txtAPP");
Label lblTotalAmount = (Label)item.FindControl("lblTotalAmount");
if (txtUnitNo.Text != "" && txtAPP.Text != "")
{
lblTotalAmount.Text = (decimal.Parse(txtUnitNo.Text) * decimal.Parse(txtAPP.Text)).ToString();
uppanel.Update();
}
}
}
//findTotalAmount();
}
catch
{
}
finally
{
uppanel.Update();
}
}
protected void AddDescription(GridView gv, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
TextBox txtUnitNo = (TextBox)item.FindControl("txtUnitNo");
TextBox txtAPP = (TextBox)item.FindControl("txtAPP");
Label lblDeatilsID = (Label)item.FindControl("lblDeatilsID");
Label lblTotalAmount = (Label)item.FindControl("lblTotalAmount");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Description");
dt.Columns.Add("UnitNo");
dt.Columns.Add("AmountPerPerson");
dt.Columns.Add("TotalAmount");
dt.Columns.Add("DetailID");
}
DataRow dr = dt.NewRow();
dr["Description"] = txtDescription.Text;
dr["UnitNo"] = txtUnitNo.Text;
dr["AmountPerPerson"] = txtAPP.Text;
dr["TotalAmount"] = lblTotalAmount.Text;
dr["DetailID"] = lblDeatilsID.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Description");
dt.Columns.Add("UnitNo");
dt.Columns.Add("AmountPerPerson");
dt.Columns.Add("TotalAmount");
dt.Columns.Add("DetailID");
}
DataRow dr = dt.NewRow();
dr["Description"] = "";
dr["UnitNo"] = "";
dr["AmountPerPerson"] = "";
dr["TotalAmount"] = "";
dr["DetailID"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
TextBox txtUnitNo = (TextBox)item.FindControl("txtUnitNo");
TextBox txtAPP = (TextBox)item.FindControl("txtAPP");
Button btnHotelRemove = (Button)item.FindControl("btnHotelRemove");
Label lblDeatilsID = (Label)item.FindControl("lblDeatilsID");
Label lblTotalAmount = (Label)item.FindControl("lblTotalAmount");
if (ViewState["RowCount"] != null)
{
if (itm <= int.Parse(ViewState["RowCount"].ToString()))
{
btnHotelRemove.Visible = false;
}
else
{
}
}
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
//bindInvoiceFromSupplier(k);
txtDescription.Text = dt.Rows[itm]["Description"].ToString();
txtUnitNo.Text = dt.Rows[itm]["UnitNo"].ToString();
txtAPP.Text = dt.Rows[itm]["AmountPerPerson"].ToString();
lblDeatilsID.Text = dt.Rows[itm]["DetailID"].ToString();
lblTotalAmount.Text = dt.Rows[itm]["TotalAmount"].ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void HotelValidation(GridView gv_Hotel, UpdatePanel upPanel)
{
DropDownList hotel = new DropDownList();
DropDownList roomtype = new DropDownList();
hotel = (DropDownList)gv_Hotel.Rows[0].FindControl("drpHotelName");
roomtype = (DropDownList)gv_Hotel.Rows[0].FindControl("drpRoomType");
DropDownList hotel0 = new DropDownList();
DropDownList roomtype0 = new DropDownList();
try
{
for (int i = 0; i < gv_Hotel.Rows.Count; i++)
{
hotel = (DropDownList)gv_Hotel.Rows[i].FindControl("drpHotelName");
roomtype = (DropDownList)gv_Hotel.Rows[i].FindControl("drpRoomType");
for (int j = 1; j < gv_Hotel.Rows.Count; j++)
{
hotel0 = (DropDownList)gv_Hotel.Rows[j].FindControl("drpHotelName");
roomtype0 = (DropDownList)gv_Hotel.Rows[j].FindControl("drpRoomType");
if ((hotel0.Text == hotel.Text) && (roomtype0.Text == roomtype.Text) && (i != j))
{
roomtype0.Text = "";
Master.DisplayMessage("Hotel Not Allowed Same Room Type.", "successMessage", 5000);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
upPanel.Update();
}
}
protected void addServices(GridView gv, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
TextBox txtServices = (TextBox)item.FindControl("txtServices");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtNoPax = (TextBox)item.FindControl("txtNoPax");
DropDownList drpSupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtNetPrice = (TextBox)item.FindControl("txtNetPrice");
TextBox txtSellPrice = (TextBox)item.FindControl("txtSellPrice");
TextBox txtFrom = (TextBox)item.FindControl("txtFrom");
TextBox txtTo = (TextBox)item.FindControl("txtTo");
TextBox txtPassenger = (TextBox)item.FindControl("txtNoOfPassanger");
CheckBox chkaditional = (CheckBox)item.FindControl("chkAditional");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Seriveces");
dt.Columns.Add("Date");
dt.Columns.Add("NoPax");
dt.Columns.Add("Supplier");
dt.Columns.Add("NetPrice");
dt.Columns.Add("SellPrice");
dt.Columns.Add("From");
dt.Columns.Add("To");
dt.Columns.Add("NoOfPassanger");
dt.Columns.Add("chkAditional");
}
DataRow dr = dt.NewRow();
dr["Seriveces"] = txtServices.Text;
dr["Date"] = txtDate.Text;
dr["NoPax"] = txtNoPax.Text;
dr["Supplier"] = drpSupplier.Text;
dr["NetPrice"] = txtNetPrice.Text;
dr["SellPrice"] = txtSellPrice.Text;
dr["From"] = txtFrom.Text;
dr["To"] = txtTo.Text;
dr["NoOfPassanger"] = txtPassenger.Text;
dr["chkAditional"] = chkaditional.Checked;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Seriveces");
dt.Columns.Add("Date");
dt.Columns.Add("NoPax");
dt.Columns.Add("Supplier");
dt.Columns.Add("NetPrice");
dt.Columns.Add("SellPrice");
dt.Columns.Add("From");
dt.Columns.Add("To");
dt.Columns.Add("NoOfPassanger");
dt.Columns.Add("chkAditional");
}
DataRow dr = dt.NewRow();
dr["Seriveces"] = "";
dr["Date"] = "";
dr["NoPax"] = "";
dr["Supplier"] = "";
dr["NetPrice"] = "";
dr["SellPrice"] = "";
dr["From"] = "";
dr["To"] = "";
dr["NoOfPassanger"] = "";
dr["chkAditional"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
TextBox txtServices = (TextBox)item.FindControl("txtServices");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtNoPax = (TextBox)item.FindControl("txtNoPax");
DropDownList drpSupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtNetPrice = (TextBox)item.FindControl("txtNetPrice");
TextBox txtSellPrice = (TextBox)item.FindControl("txtSellPrice");
TextBox txtFrom = (TextBox)item.FindControl("txtFrom");
TextBox txtTo = (TextBox)item.FindControl("txtTo");
TextBox txtPassenger = (TextBox)item.FindControl("txtNoOfPassanger");
CheckBox chkaditional = (CheckBox)item.FindControl("chkAditional");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
txtServices.Text = dt.Rows[itm]["Seriveces"].ToString();
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtNoPax.Text = dt.Rows[itm]["NoPax"].ToString();
DataSet dsadditional = objHotelStoreProcedure.fetchComboData("GET_CHAIN_NAME_FOR_ADDITIONAL_SERVICES", "");
binddropdownlist(drpSupplier, dsadditional);
drpSupplier.Text = dt.Rows[itm]["Supplier"].ToString();
txtNetPrice.Text = dt.Rows[itm]["NetPrice"].ToString(); ;
txtSellPrice.Text = dt.Rows[itm]["SellPrice"].ToString();
txtFrom.Text = dt.Rows[itm]["From"].ToString();
txtTo.Text = dt.Rows[itm]["To"].ToString();
txtPassenger.Text = dt.Rows[itm]["NoOfPassanger"].ToString();
if (dt.Rows[itm]["chkAditional"].ToString() == "True")
{
chkaditional.Checked = true;
}
else
{
chkaditional.Checked = false;
}
}
}
}
if (RoleId != "18")
{
divAddServ.Visible = false;
lbladdservice.Visible = false;
}
if (Session["OrderStatus"].ToString() == "To Be Reconfirmed")
{
TextBox txtNoOfPassanger = new TextBox();
Label lblpassenger = new Label();
Label lbladd = new Label();
CheckBox chkadd = new CheckBox();
btnpessSave.Visible = true;
for (int i = 0; i < gv.Rows.Count; i++)
{
lblpassenger = (Label)gv.HeaderRow.FindControl("lblpassenger");
lblpassenger.Visible = true;
txtNoOfPassanger = (TextBox)gv.Rows[i].FindControl("txtNoOfPassanger");
txtNoOfPassanger.Visible = true;
lbladd = (Label)gv.HeaderRow.FindControl("lblchkad");
lbladd.Visible = true;
chkadd = (CheckBox)gv.Rows[i].FindControl("chkAditional");
chkadd.Visible = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void AddHotels(GridView gv, string CityName, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
DataSet ds = objGitDetail.fetchComboDataforHotel("FETCH_HOTEL_NAME_FOR_GIT_CITY_WISE", CityName);
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpHotelName = (DropDownList)item.FindControl("drpHotelName");
DropDownList drpRoomType = (DropDownList)item.FindControl("drpRoomType");
TextBox txtCheckInDate = (TextBox)item.FindControl("txtCheckInDate");
TextBox txtCheckOutDate = (TextBox)item.FindControl("txtCheckOutDate");
TextBox txtNights = (TextBox)item.FindControl("txtNights");
CheckBox chk = (CheckBox)item.FindControl("chkAddToCart");
TextBox txtSingleRoom = (TextBox)item.FindControl("txtSingleRoom");
TextBox txtDoubleRoom = (TextBox)item.FindControl("txtDoubleRoom");
TextBox txtTripleRoom = (TextBox)item.FindControl("txtTripleRoom");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("HotelName");
dt.Columns.Add("RoomType");
dt.Columns.Add("CheckInDate");
dt.Columns.Add("CheckOutDate");
dt.Columns.Add("Nights");
dt.Columns.Add("AddCart");
dt.Columns.Add("SingleRoom");
dt.Columns.Add("DoubleRoom");
dt.Columns.Add("TripleRoom");
}
DataRow dr = dt.NewRow();
dr["HotelName"] = drpHotelName.Text;
dr["RoomType"] = drpRoomType.Text;
dr["CheckInDate"] = txtCheckInDate.Text;
dr["CheckOutDate"] = txtCheckOutDate.Text;
dr["Nights"] = txtNights.Text;
dr["SingleRoom"] = txtSingleRoom.Text;
dr["DoubleRoom"] = txtDoubleRoom.Text;
dr["TripleRoom"] = txtTripleRoom.Text;
if (chk.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("HotelName");
dt.Columns.Add("RoomType");
dt.Columns.Add("CheckInDate");
dt.Columns.Add("CheckOutDate");
dt.Columns.Add("Nights");
dt.Columns.Add("AddCart");
dt.Columns.Add("SingleRoom");
dt.Columns.Add("DoubleRoom");
dt.Columns.Add("TripleRoom");
}
DataRow dr = dt.NewRow();
dr["HotelName"] = "";
dr["RoomType"] = "";
dr["CheckInDate"] = "";
dr["CheckOutDate"] = "";
dr["Nights"] = "";
dr["AddCart"] = "";
dr["SingleRoom"] = "";
dr["DoubleRoom"] = "";
dr["TripleRoom"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
DropDownList drpHotelName = (DropDownList)item.FindControl("drpHotelName");
DropDownList drpRoomType = (DropDownList)item.FindControl("drpRoomType");
TextBox txtCheckInDate = (TextBox)item.FindControl("txtCheckInDate");
TextBox txtCheckOutDate = (TextBox)item.FindControl("txtCheckOutDate");
TextBox txtNights = (TextBox)item.FindControl("txtNights");
CheckBox chk = (CheckBox)item.FindControl("chkAddToCart");
TextBox txtSingleRoom = (TextBox)item.FindControl("txtSingleRoom");
TextBox txtDoubleRoom = (TextBox)item.FindControl("txtDoubleRoom");
TextBox txtTripleRoom = (TextBox)item.FindControl("txtTripleRoom");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpHotelName, ds);
drpHotelName.Text = dt.Rows[itm]["HotelName"].ToString();
if (drpHotelName.Text != "")
{
DataSet ds1 = objGitDetail.fetchComboDataforHotelroomtype("FETCH_ROOM_TYPE_FOR_GIT_HOTEL_WISE", drpHotelName.Text, CityName);
binddropdownlist(drpRoomType, ds1);
drpRoomType.Text = dt.Rows[itm]["RoomType"].ToString();
}
txtCheckInDate.Text = dt.Rows[itm]["CheckInDate"].ToString();
txtCheckOutDate.Text = dt.Rows[itm]["CheckOutDate"].ToString();
txtNights.Text = dt.Rows[itm]["Nights"].ToString();
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
txtSingleRoom.Text = dt.Rows[itm]["SingleRoom"].ToString();
txtDoubleRoom.Text = dt.Rows[itm]["DoubleRoom"].ToString();
txtTripleRoom.Text = dt.Rows[itm]["TripleRoom"].ToString();
}
}
}
if (RoleId != "18")
{
Button RateButton = new Button();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnHotelRate");
RateButton.Visible = false;
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
{
Button RateButton = new Button();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnHotelRate");
RateButton.Visible = false;
}
}
if (RoleId == "18" && (Session["OrderStatus"].ToString() == "Booked" || Session["OrderStatus"].ToString() == "To Be Reconfirmed"))
{
if (ViewState["RadioBtnVsible"] != null)
{
RadioButton ConfirmrdoButton = new RadioButton();
for (int i = 0; i < gv.Rows.Count - 1; i++)
{
if (i == int.Parse(ViewState["RadioBtnVsible"].ToString()))
{
ConfirmrdoButton = (RadioButton)gv.Rows[i].FindControl("rdoConfirm");
ConfirmrdoButton.Visible = true;
ViewState["RadioBtnVsible"] = null;
break;
}
}
}
}
if (Session["OrderStatus"].ToString() == "To Be Reconfirmed")
{
if (ViewState["RoomtxtVsible"] != null)
{
TextBox txtSingleRoom = new TextBox();
TextBox txtDoubleRoom = new TextBox();
TextBox txtTripleRoom = new TextBox();
for (int i = 0; i < gv.Rows.Count - 1; i++)
{
if (i == int.Parse(ViewState["RoomtxtVsible"].ToString()))
{
txtSingleRoom = (TextBox)gv.Rows[i].FindControl("txtSingleRoom");
txtSingleRoom.Visible = true;
txtDoubleRoom = (TextBox)gv.Rows[i].FindControl("txtDoubleRoom");
txtDoubleRoom.Visible = true;
txtTripleRoom = (TextBox)gv.Rows[i].FindControl("txtTripleRoom");
txtTripleRoom.Visible = true;
ViewState["RoomtxtVsible"] = null;
break;
}
}
if (gv.HeaderRow != null)
{
Label lblSingleRoom = (Label)gv.HeaderRow.FindControl("lblSingleRoom");
lblSingleRoom.Visible = true;
Label lblDoubleRoom = (Label)gv.HeaderRow.FindControl("lblDoubleRoom");
lblDoubleRoom.Visible = true;
Label lblTripleRoom = (Label)gv.HeaderRow.FindControl("lblTripleRoom");
lblTripleRoom.Visible = true;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void RemoveGalaDinner(GridView gv, string CityName, UpdatePanel uppanel, int rowIndex)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
DataSet ds = objGitDetail.fetchConfGala("GET_GALA_DINNER_HOTEL", CityName);
foreach (GridViewRow item in gv.Rows)
{
CheckBox chkGala = (CheckBox)item.FindControl("chkGala");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpGalaType = (DropDownList)item.FindControl("drpGalaType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("GalaType");
dt.Columns.Add("Hotel");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
}
DataRow dr = dt.NewRow();
dr["Date"] = txtDate.Text;
dr["GalaType"] = drpGalaType.Text;
dr["Hotel"] = drpHotel.Text;
dr["ChildRate"] = txtchildRate.Text;
dr["AdultRate"] = txtadultRate.Text;
dr["ReconfirmedDate"] = txtReconfirmedDate.Text;
if (chkGala.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
CheckBox chkGala = (CheckBox)item.FindControl("chkGala");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpGalaType = (DropDownList)item.FindControl("drpGalaType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpHotel, ds);
drpHotel.Text = dt.Rows[itm]["Hotel"].ToString();
if (Request["TOURID"] != null && !string.IsNullOrEmpty(Request["TOURID"].ToString()))
{
if (drpHotel.Text != "")
{
DataSet dsGalaType = objGitDetail.CommonSp("GET_GALA_DINNER_TYPE");
binddropdownlist(drpGalaType, dsGalaType);
drpGalaType.Text = dt.Rows[itm]["GalaType"].ToString();
}
}
else
{
DataSet dsGalaType = objGitDetail.CommonSp("GET_GALA_DINNER_TYPE");
binddropdownlist(drpGalaType, dsGalaType);
drpGalaType.Text = dt.Rows[itm]["GalaType"].ToString();
}
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtchildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtadultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chkGala.Checked = true;
}
else
{
chkGala.Checked = false;
}
txtReconfirmedDate.Text = dt.Rows[itm]["ReconfirmedDate"].ToString();
}
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() == "Booked")
{
TextBox txtReconfirmedDate = new TextBox();
Label lblReconfirmedDate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
txtReconfirmedDate = (TextBox)gv.Rows[i].FindControl("txtReconfirmedDate");
txtReconfirmedDate.Visible = true;
lblReconfirmedDate = (Label)gv.HeaderRow.FindControl("lblReconfirmedDate");
lblReconfirmedDate.Visible = true;
}
}
//if (RoleId != "18")
//{
// Button RateButton = new Button();
// TextBox ChildRate = new TextBox();
// TextBox AdultRate = new TextBox();
// Label lblchildrate = new Label();
// Label lbladultrate = new Label();
// for (int i = 0; i < gv.Rows.Count; i++)
// {
// RateButton = (Button)gv.Rows[i].FindControl("btnGalaDinnerRate");
// RateButton.Visible = false;
// ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
// AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
// ChildRate.Visible = false;
// AdultRate.Visible = false;
// gv.Columns[4].Visible = false;
// gv.Columns[5].Visible = false;
// gv.Columns[6].Visible = false;
// }
//}
//if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
//{
// Button RateButton = new Button();
// TextBox ChildRate = new TextBox();
// TextBox AdultRate = new TextBox();
// Label lblchildrate = new Label();
// Label lbladultrate = new Label();
// for (int i = 0; i < gv.Rows.Count; i++)
// {
// RateButton = (Button)gv.Rows[i].FindControl("btnGalaDinnerRate");
// RateButton.Visible = false;
// ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
// AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
// ChildRate.Visible = false;
// AdultRate.Visible = false;
// gv.Columns[4].Visible = false;
// gv.Columns[5].Visible = false;
// gv.Columns[6].Visible = false;
// }
//}
if (Session["OrderStatus"].ToString() == "In Process")
{
Button RateButton = new Button();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnGalaDinnerRate");
RateButton.Visible = false;
TextBox ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
TextBox AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
}
uppanel.Update();
}
protected void AddTime(GridView gv, UpdatePanel uppanel)
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
Label lblfrom = (Label)item.FindControl("lblFrom");
Label lblto = (Label)item.FindControl("lblTo");
DropDownList drptime = (DropDownList)item.FindControl("drpTime");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("FROM_NAME");
dt.Columns.Add("TO_NAME");
dt.Columns.Add("TIME");
}
DataRow dr = dt.NewRow();
dr["FROM_NAME"] = lblfrom.Text;
dr["TO_NAME"] = lblto.Text;
dr["TIME"] = drptime.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("FROM_NAME");
dt.Columns.Add("TO_NAME");
dt.Columns.Add("TIME");
}
DataRow dr = dt.NewRow();
dr["FROM_NAME"] = "";
dr["TO_NAME"] = "";
dr["TIME"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
Label lblfrom = (Label)item.FindControl("lblFrom");
Label lblto = (Label)item.FindControl("lblTo");
DropDownList drptime = (DropDownList)item.FindControl("drpTime");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
DataSet ds = objTransferPackageTimeMapping.fetchComboData("FETCH_ALL_TRANSFER_PACKAGE_TIMING");
binddropdownlist(drptime, ds);
lblfrom.Text = dt.Rows[0]["FROM_NAME"].ToString();
lblto.Text = dt.Rows[0]["TO_NAME"].ToString();
drptime.Text = dt.Rows[itm]["TIME"].ToString();
}
}
}
uppanel.Update();
}
protected void removeRow(GridView gv, int rowIndex, UpdatePanel uppanel)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpInvoiceNo = (DropDownList)item.FindControl("drpInvoiceNo");
Label lblAmount = (Label)item.FindControl("lblTotalAmount");
TextBox txtSettleAmount = (TextBox)item.FindControl("txtSettledAmount");
TextBox txtInvoiceAmount = (TextBox)item.FindControl("txtInvoiceAmount");
Label lblRemaingBalance = (Label)item.FindControl("lblRemaingBalance");
Label lblAmountSettled = (Label)item.FindControl("lblAmountSettled");
//Label lblRemaingBalance = (Label)item.FindControl("lblRemaingBalance");
//Label lblAmountValidate = (Label)item.FindControl("lblAmountValidate");
TextBox txtInvoiceAmountTHB = (TextBox)item.FindControl("txtInvoiceAmountTHB");
Label lblTourName = (Label)item.FindControl("lblTourName");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("Amount");
dt.Columns.Add("SettleAmount");
dt.Columns.Add("InvoiceAmount");
dt.Columns.Add("lblRemaingBalance");
dt.Columns.Add("lblAmountSettled");
//dt.Columns.Add("RemainingAmount");
//dt.Columns.Add("ValidateAmount");
dt.Columns.Add("InvoiceAmountTHB");
dt.Columns.Add("TourName");
}
DataRow dr = dt.NewRow();
dr["InvoiceNo"] = drpInvoiceNo.Text;
dr["Amount"] = lblAmount.Text;
dr["SettleAmount"] = txtSettleAmount.Text;
dr["InvoiceAmount"] = txtInvoiceAmount.Text;
// dr["RemainingAmount"] = lblRemaingBalance.Text;
//dr["ValidateAmount"] = lblAmountValidate.Text;
dr["lblRemaingBalance"] = "";
dr["lblAmountSettled"] = "";
dr["InvoiceAmountTHB"] = txtInvoiceAmountTHB.Text;
dr["TourName"] = lblTourName.Text;
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
int itm1 = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
DropDownList drpInvoiceNo = (DropDownList)item.FindControl("drpInvoiceNo");
Label lblAmount = (Label)item.FindControl("lblTotalAmount");
TextBox txtSettleAmount = (TextBox)item.FindControl("txtSettledAmount");
TextBox txtInvoiceAmount = (TextBox)item.FindControl("txtInvoiceAmount");
Label lblRemaingBalance = (Label)item.FindControl("lblRemaingBalance");
Label lblAmountSettled = (Label)item.FindControl("lblAmountSettled");
//Label lblRemaingBalance = (Label)item.FindControl("lblRemaingBalance");
//Label lblAmountValidate = (Label)item.FindControl("lblAmountValidate");
TextBox txtInvoiceAmountTHB = (TextBox)item.FindControl("txtInvoiceAmountTHB");
Label lblTourName = (Label)item.FindControl("lblTourName");
Button btnHotelRemove = (Button)item.FindControl("btnHotelRemove");
if (ViewState["RowCount"] != null)
{
if (itm <= int.Parse(ViewState["RowCount"].ToString()))
{
btnHotelRemove.Visible = false;
}
else
{
}
}
bindInvoiceFromSupplier(itm1);
drpInvoiceNo.Text = dt.Rows[itm]["InvoiceNo"].ToString();
lblAmount.Text = dt.Rows[itm]["Amount"].ToString();
txtSettleAmount.Text = dt.Rows[itm]["SettleAmount"].ToString();
txtInvoiceAmount.Text = dt.Rows[itm]["InvoiceAmount"].ToString();
lblRemaingBalance.Text = dt.Rows[itm]["lblRemaingBalance"].ToString();
lblAmountSettled.Text = dt.Rows[itm]["lblAmountSettled"].ToString();
// lblRemaingBalance.Text = dt.Rows[itm]["RemainingAmount"].ToString();
// lblAmountValidate.Text = dt.Rows[itm]["ValidateAmount"].ToString();
txtInvoiceAmountTHB.Text = dt.Rows[itm]["InvoiceAmountTHB"].ToString();
lblTourName.Text = dt.Rows[itm]["TourName"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void AddReceipt(GridView gv, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpinvoice = (DropDownList)item.FindControl("drpinvoice");
Label lblAmountTHB = (Label)item.FindControl("lblAmountTHB");
TextBox txtAmountSettled = (TextBox)item.FindControl("txtAmountSettled");
Label lblBalancetobepaid = (Label)item.FindControl("lblBalancetobepaid");
Label lblDetailId = (Label)item.FindControl("lblDetailId");
Label lblOldAmount = (Label)item.FindControl("lblOldAmount");
Label lblStatus = (Label)item.FindControl("lblStatus");
Label lblAmountUSD = (Label)item.FindControl("lblAmountUSD");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("Amount");
dt.Columns.Add("AmountSattled");
dt.Columns.Add("Baltobepaid");
dt.Columns.Add("DetailId");
dt.Columns.Add("lblOldAmount");
dt.Columns.Add("lblAmountUSD");
dt.Columns.Add("lblStatus");
}
DataRow dr = dt.NewRow();
dr["InvoiceNo"] = drpinvoice.Text;
dr["Amount"] = lblAmountTHB.Text;
dr["AmountSattled"] = txtAmountSettled.Text;
dr["Baltobepaid"] = lblBalancetobepaid.Text;
dr["DetailId"] = lblDetailId.Text;
dr["lblOldAmount"] = lblOldAmount.Text;
dr["lblAmountUSD"] = lblAmountUSD.Text;
dr["lblStatus"] = lblStatus.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("InvoiceNo");
dt.Columns.Add("Amount");
dt.Columns.Add("AmountSattled");
dt.Columns.Add("Baltobepaid");
dt.Columns.Add("DetailId");
dt.Columns.Add("lblOldAmount");
dt.Columns.Add("lblAmountUSD");
dt.Columns.Add("lblStatus");
}
DataRow dr = dt.NewRow();
dr["InvoiceNo"] = "";
dr["Amount"] = "";
dr["AmountSattled"] = "";
dr["Baltobepaid"] = "";
dr["DetailId"] = "";
dr["lblOldAmount"] = "";
dr["lblAmountUSD"] = "";
dr["lblStatus"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
DropDownList drpinvoice = (DropDownList)item.FindControl("drpinvoice");
Label lblAmountTHB = (Label)item.FindControl("lblAmountTHB");
TextBox txtAmountSettled = (TextBox)item.FindControl("txtAmountSettled");
Label lblBalancetobepaid = (Label)item.FindControl("lblBalancetobepaid");
Label lblDetailId = (Label)item.FindControl("lblDetailId");
Label lblOldAmount = (Label)item.FindControl("lblOldAmount");
Label lblAmountUSD = (Label)item.FindControl("lblAmountUSD");
Label lblStatus = (Label)item.FindControl("lblStatus");
Button btnHotelRemove = (Button)item.FindControl("btnHotelRemove");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
//binddropdownlist(drpHotelName, ds);
//drpHotelName.Text = dt.Rows[itm]["HotelName"].ToString();
if (drpagent_company_name.Text != "")
{
bindInvoiceFromSupplier(itm);
//DataSet ds = objVouchersStoredProcedure.get_cust_rel_sr_no("FETCH_EMPLOYEE_ID_FOR_PAYMENT", drpagent_company_name.Text);
//drpinvoice.Items.Clear();
//DataSet ds1 = objVouchersStoredProcedure.get_invoice_left("GET_INVOICE_NO_THB", int.Parse(ds.Tables[0].Rows[0]["USER_ID"].ToString()));
//binddropdownlist(drpinvoice, ds1);
}
else
{
DataSet ds7 = objVouchersStoredProcedure.fetch_voucher_type("FETCH_ALL_INVOICE_NO");
binddropdownlist(drpinvoice, ds7);
}
if (ViewState["RowCount"] != null)
{
if (itm <= int.Parse(ViewState["RowCount"].ToString()))
{
btnHotelRemove.Visible = false;
}
else
{
}
}
drpinvoice.Text = dt.Rows[itm]["InvoiceNo"].ToString();
lblAmountTHB.Text = dt.Rows[itm]["Amount"].ToString();
txtAmountSettled.Text = dt.Rows[itm]["AmountSattled"].ToString();
lblBalancetobepaid.Text = dt.Rows[itm]["Baltobepaid"].ToString();
lblDetailId.Text = dt.Rows[itm]["DetailId"].ToString();
lblOldAmount.Text = dt.Rows[itm]["lblOldAmount"].ToString();
lblAmountUSD.Text = dt.Rows[itm]["lblAmountUSD"].ToString();
lblStatus.Text = dt.Rows[itm]["lblStatus"].ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void fillHotelsEditMode(GridView gv, UpdatePanel uppanel)
{
try
{
DataSet ds = objVouchersStoredProcedure.get_records_for_edit("GET_EDIT_RECEIPT_VOUCHER_DETAILS", Request["VN"].ToString());
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
if (ds.Tables[0].Rows[j]["INVOICE_NO"].ToString() != "")
{
foreach (GridViewRow item in gv.Rows)
{
if (j == item.DataItemIndex + 1)
{
DropDownList drpinvoice = (DropDownList)item.FindControl("drpinvoice");
Label lblAmountTHB = (Label)item.FindControl("lblAmountTHB");
TextBox txtAmountSettled = (TextBox)item.FindControl("txtAmountSettled");
Label lblBalancetobepaid = (Label)item.FindControl("lblBalancetobepaid");
Label lblDetailId = (Label)item.FindControl("lblDetailId");
Label lblOldAmount = (Label)item.FindControl("lblOldAmount");
Label lblAmountUSD = (Label)item.FindControl("lblAmountUSD");
Label lblStatus = (Label)item.FindControl("lblStatus");
lblDetailId.Text = ds.Tables[0].Rows[j]["SALES_RECEIPT_VOUCHER_DETAIL_ID"].ToString();
drpinvoice.Text = ds.Tables[0].Rows[j]["INVOICE_NO"].ToString();
DataSet ds1 = objVouchersStoredProcedure.fetch_invoice_dateials("FETCH_DESCRIPTION_FROM_INVOICE_NO_USD", drpinvoice.Text);
lblAmountTHB.Text = ds1.Tables[0].Rows[0]["VOUCHER_AMOUNT"].ToString();
lblAmountUSD.Text = ds1.Tables[0].Rows[0]["INVOICE_AMOUNT"].ToString();
lblStatus.Text = ds1.Tables[0].Rows[0]["ORDER_STATUS_NAME"].ToString();
txtAmountSettled.Text = ds.Tables[0].Rows[j]["DETAILS_FOREX"].ToString();
lblBalancetobepaid.Text = get_balance_be_paid(ds1.Tables[0].Rows[0]["total_amount"].ToString(), drpinvoice.Text);
lblOldAmount.Text = (decimal.Parse(lblBalancetobepaid.Text) + decimal.Parse(txtAmountSettled.Text)).ToString();
}
}
if (j < ds.Tables[0].Rows.Count - 1)
{
AddReceipt(gv, uppanel);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void BoatremoveRow(GridView gv, int rowIndex, UpdatePanel uppanel)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
foreach (GridViewRow item in gv.Rows)
{
if (rowIndex != item.DataItemIndex)
{
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofBoats = (TextBox)item.FindControl("txtBoats");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtdate = (TextBox)item.FindControl("txtDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
Label lblPackid = (Label)item.FindControl("lblPackid");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("GIT_TRANSFER_PACKGE_NAME");
dt.Columns.Add("NoofBoats");
dt.Columns.Add("Supplier");
dt.Columns.Add("Date");
dt.Columns.Add("Time");
dt.Columns.Add("Id");
}
DataRow dr = dt.NewRow();
dr["GIT_TRANSFER_PACKGE_NAME"] = txtPackagename.Text;
dr["NoofBoats"] = txtNoofBoats.Text;
dr["Supplier"] = drpsupplier.Text;
dr["Date"] = txtdate.Text;
dr["Time"] = txttime.SelectedDate;
dr["Id"] = lblPackid.Text;
dt.Rows.Add(dr);
}
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofBoats = (TextBox)item.FindControl("txtBoats");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtdate = (TextBox)item.FindControl("txtDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
fillBoatSupplier(gridBoat, itm);
txtPackagename.Text = dt.Rows[0]["GIT_TRANSFER_PACKGE_NAME"].ToString();
txtNoofBoats.Text = dt.Rows[itm]["NoofBoats"].ToString();
drpsupplier.Text = dt.Rows[itm]["Supplier"].ToString();
txtdate.Text = dt.Rows[itm]["Date"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void AddBoat(GridView gv, UpdatePanel uppanel)
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofBoats = (TextBox)item.FindControl("txtBoats");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtdate = (TextBox)item.FindControl("txtDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
Label lblPackid = (Label)item.FindControl("lblPackid");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("GIT_TRANSFER_PACKGE_NAME");
dt.Columns.Add("NoofBoats");
dt.Columns.Add("Supplier");
dt.Columns.Add("Date");
dt.Columns.Add("Time");
dt.Columns.Add("Id");
}
DataRow dr = dt.NewRow();
dr["GIT_TRANSFER_PACKGE_NAME"] = txtPackagename.Text;
dr["NoofBoats"] = txtNoofBoats.Text;
dr["Supplier"] = drpsupplier.Text;
dr["Date"] = txtdate.Text;
dr["Time"] = txttime.SelectedDate;
dr["Id"] = lblPackid.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("GIT_TRANSFER_PACKGE_NAME");
dt.Columns.Add("NoofBoats");
dt.Columns.Add("Supplier");
dt.Columns.Add("Date");
dt.Columns.Add("Time");
dt.Columns.Add("Id");
}
DataRow dr = dt.NewRow();
dr["GIT_TRANSFER_PACKGE_NAME"] = "";
dr["NoofBoats"] = "";
dr["Supplier"] = "";
dr["Date"] = "";
dr["Time"] = "";
dr["Id"] = "0";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dr1["Id"] = "0";
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofBoats = (TextBox)item.FindControl("txtBoats");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtdate = (TextBox)item.FindControl("txtDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
fillBoatSupplier(gridBoat, itm);
txtPackagename.Text = dt.Rows[0]["GIT_TRANSFER_PACKGE_NAME"].ToString();
txtNoofBoats.Text = dt.Rows[itm]["NoofBoats"].ToString();
drpsupplier.Text = dt.Rows[itm]["Supplier"].ToString();
txtdate.Text = dt.Rows[itm]["Date"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
}
}
}
uppanel.Update();
}
protected void AddGuide(GridView gv, UpdatePanel uppanel)
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
foreach (GridViewRow item in gv.Rows)
{
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofNights = (TextBox)item.FindControl("txtNights");
TextBox txtNoofGuides = (TextBox)item.FindControl("txtGuides");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("GIT_TRANSFER_PACKGE_NAME");
dt.Columns.Add("NoofNights");
dt.Columns.Add("NoofGuides");
dt.Columns.Add("Supplier");
}
DataRow dr = dt.NewRow();
dr["GIT_TRANSFER_PACKGE_NAME"] = txtPackagename.Text;
dr["NoofNights"] = txtNoofNights.Text;
dr["NoofGuides"] = txtNoofGuides.Text;
dr["Supplier"] = drpsupplier.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("GIT_TRANSFER_PACKGE_NAME");
dt.Columns.Add("NoofNights");
dt.Columns.Add("NoofGuides");
dt.Columns.Add("Supplier");
}
DataRow dr = dt.NewRow();
dr["GIT_TRANSFER_PACKGE_NAME"] = "";
dr["NoofNights"] = "";
dr["NoofGuides"] = "";
dr["Supplier"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
Label txtPackagename = (Label)item.FindControl("lblPackName");
TextBox txtNoofNights = (TextBox)item.FindControl("txtNights");
TextBox txtNoofGuides = (TextBox)item.FindControl("txtGuides");
DropDownList drpsupplier = (DropDownList)item.FindControl("drpSupplier");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
fillGuideSupplier(gridGuide);
txtPackagename.Text = dt.Rows[0]["GIT_TRANSFER_PACKGE_NAME"].ToString();
txtNoofNights.Text = dt.Rows[itm]["NoofNights"].ToString();
txtNoofGuides.Text = dt.Rows[itm]["NoofGuides"].ToString();
drpsupplier.Text = dt.Rows[itm]["Supplier"].ToString();
}
}
}
uppanel.Update();
}
protected void RemoveConference(GridView gv, string CityName, UpdatePanel uppanel, int rowIndex)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
DataSet ds = objGitDetail.fetchConfGala("GET_CONFERENCE_HOTEL", CityName);
foreach (GridViewRow item in gv.Rows)
{
CheckBox chk = (CheckBox)item.FindControl("chkConf");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpConfType = (DropDownList)item.FindControl("drpConfType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("ConferenceType");
dt.Columns.Add("Hotel");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("Time");
dt.Columns.Add("ReconfirmedDate");
}
DataRow dr = dt.NewRow();
dr["Date"] = txtDate.Text;
dr["ConferenceType"] = drpConfType.Text;
dr["Hotel"] = drpHotel.Text;
dr["ChildRate"] = txtchildRate.Text;
dr["AdultRate"] = txtadultRate.Text;
dr["Time"] = txttime.SelectedDate;
dr["ReconfirmedDate"] = txtReconfirmedDate.Text;
if (chk.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
CheckBox chk = (CheckBox)item.FindControl("chkConf");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpConfType = (DropDownList)item.FindControl("drpConfType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpHotel, ds);
drpHotel.Text = dt.Rows[itm]["Hotel"].ToString();
if (Request["TOURID"] != null && !string.IsNullOrEmpty(Request["TOURID"].ToString()))
{
if (drpHotel.Text != "")
{
DataSet ds_ConfType = objGitDetail.CommonSp("GET_CONFERENCE_TYPE");
binddropdownlist(drpConfType, ds_ConfType);
drpConfType.Text = dt.Rows[itm]["ConferenceType"].ToString();
}
}
else
{
DataSet ds_ConfType = objGitDetail.CommonSp("GET_CONFERENCE_TYPE");
binddropdownlist(drpConfType, ds_ConfType);
drpConfType.Text = dt.Rows[itm]["ConferenceType"].ToString();
}
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtchildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtadultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
txtReconfirmedDate.Text = dt.Rows[itm]["ReconfirmedDate"].ToString();
}
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() == "Booked")
{
TextBox txtReconfirmedDate = new TextBox();
Label lblReconfirmedDate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
txtReconfirmedDate = (TextBox)gv.Rows[i].FindControl("txtReconfirmedDate");
txtReconfirmedDate.Visible = true;
lblReconfirmedDate = (Label)gv.HeaderRow.FindControl("lblReconfirmedDate");
lblReconfirmedDate.Visible = true;
}
}
if (Session["OrderStatus"].ToString() == "In Process")
{
Button RateButton = new Button();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnConferenceRate");
RateButton.Visible = false;
TextBox ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
TextBox AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void addGalaDinner(GridView gv, string CityName, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
DataSet ds = objGitDetail.fetchConfGala("GET_GALA_DINNER_HOTEL", CityName);
foreach (GridViewRow item in gv.Rows)
{
CheckBox chkGala = (CheckBox)item.FindControl("chkGala");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpGalaType = (DropDownList)item.FindControl("drpGalaType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("GalaType");
dt.Columns.Add("Hotel");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
dt.Columns.Add("time");
}
DataRow dr = dt.NewRow();
dr["Date"] = txtDate.Text;
dr["GalaType"] = drpGalaType.Text;
dr["Hotel"] = drpHotel.Text;
dr["ChildRate"] = txtchildRate.Text;
dr["AdultRate"] = txtadultRate.Text;
dr["ReconfirmedDate"] = txtReconfirmedDate.Text;
if (chkGala.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dr["time"] = txttime.SelectedDate.ToString();
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("GalaType");
dt.Columns.Add("Hotel");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
dt.Columns.Add("time");
}
DataRow dr = dt.NewRow();
dr["Date"] = "";
dr["GalaType"] = "";
dr["Hotel"] = "";
dr["AddCart"] = "";
dr["ChildRate"] = "";
dr["AdultRate"] = "";
dr["ReconfirmedDate"] = "";
dr["time"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
CheckBox chkGala = (CheckBox)item.FindControl("chkGala");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
DropDownList drpGalaType = (DropDownList)item.FindControl("drpGalaType");
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotel");
TextBox txtchildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtadultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpHotel, ds);
drpHotel.Text = dt.Rows[itm]["Hotel"].ToString();
if (Request["TOURID"] != null && !string.IsNullOrEmpty(Request["TOURID"].ToString()))
{
DataSet dsGalaType = objGitDetail.CommonSp("GET_GALA_DINNER_TYPE");
binddropdownlist(drpGalaType, dsGalaType);
if (drpHotel.Text != "")
{
drpGalaType.Text = dt.Rows[itm]["GalaType"].ToString();
}
}
else
{
DataSet dsGalaType = objGitDetail.CommonSp("GET_GALA_DINNER_TYPE");
binddropdownlist(drpGalaType, dsGalaType);
drpGalaType.Text = dt.Rows[itm]["GalaType"].ToString();
}
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtchildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtadultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chkGala.Checked = true;
}
else
{
chkGala.Checked = false;
}
txtReconfirmedDate.Text = dt.Rows[itm]["ReconfirmedDate"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
}
}
}
if (RoleId != "18")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblchildrate = new Label();
Label lbladultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnGalaDinnerRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
//gv.Columns[4].Visible = false;
//gv.Columns[5].Visible = false;
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblchildrate = new Label();
Label lbladultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnGalaDinnerRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
//gv.Columns[4].Visible = false;
//gv.Columns[5].Visible = false;
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() == "Booked")
{
if (ViewState["PaymentDatetxtVsible"] != null)
{
TextBox txtReconfirmedDate = new TextBox();
Label lblReconfirmedDate = new Label();
for (int i = 0; i < gv.Rows.Count - 1; i++)
{
if (i == int.Parse(ViewState["PaymentDatetxtVsible"].ToString()))
{
txtReconfirmedDate = (TextBox)gv.Rows[i].FindControl("txtReconfirmedDate");
txtReconfirmedDate.Visible = true;
lblReconfirmedDate = (Label)gv.HeaderRow.FindControl("lblReconfirmedDate");
lblReconfirmedDate.Visible = true;
ViewState["PaymentDatetxtVsible"] = null;
break;
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void fillHotelsEditMode(GridView gv, String City, UpdatePanel uppanel)
{
try
{
DataSet ds = objEditUpdateGITInformation.GetHotelName(int.Parse(tourId), City);
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
foreach (GridViewRow item in gv.Rows)
{
if (j == item.DataItemIndex)
{
DropDownList drpHotel = (DropDownList)item.FindControl("drpHotelName");
DropDownList drpRoomtype = (DropDownList)item.FindControl("drpRoomType");
TextBox txtFromdate = (TextBox)item.FindControl("txtCheckInDate");
TextBox txtTodate = (TextBox)item.FindControl("txtCheckOutDate");
TextBox txtNights = (TextBox)item.FindControl("txtNights");
CheckBox chkPackgeFlag = (CheckBox)item.FindControl("chkAddToCart");
TextBox txtSingleRoom = (TextBox)item.FindControl("txtSingleRoom");
TextBox txtDoubleRoom = (TextBox)item.FindControl("txtDoubleRoom");
TextBox txtTripleRoom = (TextBox)item.FindControl("txtTripleRoom");
drpHotel.Text = ds.Tables[0].Rows[j]["CHAIN_NAME"].ToString();
DataSet ds1 = objGitDetail.fetchComboDataforHotelroomtype("FETCH_ROOM_TYPE_FOR_GIT_HOTEL_WISE", drpHotel.Text, City);
binddropdownlist(drpRoomtype, ds1);
drpRoomtype.Text = ds.Tables[0].Rows[j]["ROOM_TYPE_NAME"].ToString();
txtFromdate.Text = ds.Tables[0].Rows[j]["FROM_DATE"].ToString();
txtTodate.Text = ds.Tables[0].Rows[j]["TO_DATE"].ToString();
txtNights.Text = ds.Tables[0].Rows[j]["NO_OF_NIGHTS"].ToString();
if (ds.Tables[0].Rows[j]["PACKAGE_FLAG"].ToString() == "True")
{
chkPackgeFlag.Checked = true;
}
RadioButton rdoConfirm = (RadioButton)item.FindControl("rdoConfirm");
if (ds.Tables[0].Rows[j]["IS_BOOKED"].ToString() == "True" && (Session["OrderStatus"].ToString() == "Booked" || Session["OrderStatus"].ToString() == "To Be Reconfirmed"))
{
ViewState["RadioBtnVsible"] = j;
rdoConfirm.Visible = true;
}
if (ds.Tables[0].Rows[j]["IS_BOOKED"].ToString() == "True" && Session["OrderStatus"].ToString() == "To Be Reconfirmed")
{
ViewState["RoomtxtVsible"] = j;
txtSingleRoom.Visible = true;
txtDoubleRoom.Visible = true;
txtTripleRoom.Visible = true;
Label lblSingleRoom = (Label)gv.HeaderRow.FindControl("lblSingleRoom");
lblSingleRoom.Visible = true;
Label lblDoubleRoom = (Label)gv.HeaderRow.FindControl("lblDoubleRoom");
lblDoubleRoom.Visible = true;
Label lblTripleRoom = (Label)gv.HeaderRow.FindControl("lblTripleRoom");
lblTripleRoom.Visible = true;
}
txtSingleRoom.Text = ds.Tables[0].Rows[j]["NO_OF_SINGLE_ROOM"].ToString();
txtDoubleRoom.Text = ds.Tables[0].Rows[j]["NO_OF_DOUBLE_ROOM"].ToString();
txtTripleRoom.Text = ds.Tables[0].Rows[j]["NO_OF_TRIPLE_ROOM"].ToString();
}
}
if (j < ds.Tables[0].Rows.Count - 1)
{
AddHotels(gv, City, uppanel);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
ViewState["RadioBtnVsible"] = null;
ViewState["RoomtxtVsible"] = null;
}
}
protected void addSite(GridView gv, UpdatePanel uppanel, String city)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
DataSet ds = objGitDetail.fetchSiteSeeing("FETCH_SIGHT_SEEING_FOR_GIT", city);
foreach (GridViewRow item in gv.Rows)
{
CheckBox chk = (CheckBox)item.FindControl("chkSiteSelect");
DropDownList drpSiteDetails = (DropDownList)item.FindControl("drpSiteDetails");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
TextBox txtDate = (TextBox)item.FindControl("txtSiteDate");
DropDownList drpSiteTime = (DropDownList)item.FindControl("drpSiteTime");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("SiteDetail");
dt.Columns.Add("AddtoCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
dt.Columns.Add("Date");
dt.Columns.Add("Time");
}
DataRow dr = dt.NewRow();
dr["SiteDetail"] = drpSiteDetails.Text;
dr["ChildRate"] = txtChildRate.Text;
dr["AdultRate"] = txtAdultRate.Text;
dr["ReconfirmedDate"] = txtReconfirmedDate.Text;
if (chk.Checked)
{
dr["AddtoCart"] = "True";
}
else
{
dr["AddtoCart"] = "False";
}
dr["Date"] = txtDate.Text;
dr["Time"] = drpSiteTime.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("SiteDetail");
dt.Columns.Add("AddtoCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
dt.Columns.Add("Date");
dt.Columns.Add("Time");
}
DataRow dr = dt.NewRow();
dr["SiteDetail"] = "";
dr["AddtoCart"] = "";
dr["ChildRate"] = "";
dr["AdultRate"] = "";
dr["ReconfirmedDate"] = "";
dr["Date"] = "";
dr["Time"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
CheckBox chk = (CheckBox)item.FindControl("chkSiteSelect");
DropDownList drpSiteDetails = (DropDownList)item.FindControl("drpSiteDetails");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
TextBox txtDate = (TextBox)item.FindControl("txtSiteDate");
DropDownList drpSiteTime = (DropDownList)item.FindControl("drpSiteTime");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpSiteDetails, ds);
drpSiteDetails.Text = dt.Rows[itm]["SiteDetail"].ToString();
if (drpSiteDetails.Text != "")
{
DataSet ds1 = objGitDetail.getTimeForSiteSeeing("GET_TIME_FOR_SITE_SEEING_GIT", drpSiteDetails.Text, city);
binddropdownlist(drpSiteTime, ds1);
drpSiteTime.Text = dt.Rows[itm]["Time"].ToString();
}
txtChildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtAdultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["AddtoCart"].ToString() == "True")
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
txtReconfirmedDate.Text = dt.Rows[itm]["ReconfirmedDate"].ToString();
txtDate.Text = dt.Rows[itm]["Date"].ToString();
}
}
}
if (RoleId != "18")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblchildrate = new Label();
Label lbladultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnSiteRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblchildrate = new Label();
Label lbladultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnSiteRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() == "Booked")
{
TextBox txtReconfirmedDate = new TextBox();
Label lblReconfirmedDate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
txtReconfirmedDate = (TextBox)gv.Rows[i].FindControl("txtReconfirmedDate");
txtReconfirmedDate.Visible = true;
lblReconfirmedDate = (Label)gv.HeaderRow.FindControl("lblReconfirmedDate");
lblReconfirmedDate.Visible = true;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void SiteSeeingValidation(GridView gv_SiteSeeing, UpdatePanel up_site)
{
DropDownList drpSiteSeeing = new DropDownList();
DropDownList drpSiteSeeing1 = new DropDownList();
string site;
string site1;
try
{
for (int i = 0; i < gv_SiteSeeing.Rows.Count; i++)
{
drpSiteSeeing = (DropDownList)gv_SiteSeeing.Rows[i].FindControl("drpSiteDetails");
site = drpSiteSeeing.Text;
for (int j = i+1; j < gv_SiteSeeing.Rows.Count; j++)
{
drpSiteSeeing1 = (DropDownList)gv_SiteSeeing.Rows[j].FindControl("drpSiteDetails");
site1 = drpSiteSeeing1.Text;
if (site == site1 && (i != j))
{
Master.DisplayMessage("Same Siteseeing Not Allowed.", "successMessage", 5000);
drpSiteSeeing1.Text = "";
up_site.Update();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
protected void RemoveSite(GridView gv, UpdatePanel uppanel, String city, int rowIndex)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
DataSet ds = objGitDetail.fetchSiteSeeing("FETCH_SIGHT_SEEING_FOR_GIT", city);
foreach (GridViewRow item in gv.Rows)
{
CheckBox chk = (CheckBox)item.FindControl("chkSiteSelect");
DropDownList drpSiteDetails = (DropDownList)item.FindControl("drpSiteDetails");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("SiteDetail");
dt.Columns.Add("AddtoCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("ReconfirmedDate");
}
DataRow dr = dt.NewRow();
dr["SiteDetail"] = drpSiteDetails.Text;
dr["ChildRate"] = txtChildRate.Text;
dr["AdultRate"] = txtAdultRate.Text;
dr["ReconfirmedDate"] = txtReconfirmedDate.Text;
if (chk.Checked)
{
dr["AddtoCart"] = "True";
}
else
{
dr["AddtoCart"] = "False";
}
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
CheckBox chk = (CheckBox)item.FindControl("chkSiteSelect");
DropDownList drpSiteDetails = (DropDownList)item.FindControl("drpSiteDetails");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
TextBox txtReconfirmedDate = (TextBox)item.FindControl("txtReconfirmedDate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpSiteDetails, ds);
drpSiteDetails.Text = dt.Rows[itm]["SiteDetail"].ToString();
txtChildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtAdultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["AddtoCart"].ToString() == "True")
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
txtReconfirmedDate.Text = dt.Rows[itm]["ReconfirmedDate"].ToString();
}
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() == "Booked")
{
TextBox txtReconfirmedDate = new TextBox();
Label lblReconfirmedDate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
txtReconfirmedDate = (TextBox)gv.Rows[i].FindControl("txtReconfirmedDate");
txtReconfirmedDate.Visible = true;
lblReconfirmedDate = (Label)gv.HeaderRow.FindControl("lblReconfirmedDate");
lblReconfirmedDate.Visible = true;
}
}
if (Session["OrderStatus"].ToString() == "In Process")
{
Button RateButton = new Button();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnSiteRate");
RateButton.Visible = false;
TextBox ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
TextBox AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
}
uppanel.Update();
}
protected void UncheckAllotherOnCheckChanged(GridView gv, UpdatePanel up, object sender)
{
foreach (GridViewRow item in gv.Rows)
{
RadioButton rb = (RadioButton)item.FindControl("rdoConfirm");
rb.Checked = false;
}
up.Update();
}
protected void RemoveService(GridView gv, UpdatePanel uppanel, int rowIndex)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
// DataSet ds = objBookingFitStoreProcedure.fetchComboData("GET_MEALS");
foreach (GridViewRow item in gv.Rows)
{
TextBox txtServices = (TextBox)item.FindControl("txtServices");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtNoPax = (TextBox)item.FindControl("txtNoPax");
DropDownList drpSupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtNetPrice = (TextBox)item.FindControl("txtNetPrice");
TextBox txtSellPrice = (TextBox)item.FindControl("txtSellPrice");
TextBox txtFrom = (TextBox)item.FindControl("txtFrom");
TextBox txtTo = (TextBox)item.FindControl("txtTo");
TextBox txtPassenger = (TextBox)item.FindControl("txtNoOfPassanger");
CheckBox chkaditional = (CheckBox)item.FindControl("chkAditional");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Seriveces");
dt.Columns.Add("Date");
dt.Columns.Add("NoPax");
dt.Columns.Add("Supplier");
dt.Columns.Add("NetPrice");
dt.Columns.Add("SellPrice");
dt.Columns.Add("From");
dt.Columns.Add("To");
dt.Columns.Add("NoOfPassanger");
dt.Columns.Add("chkAditional");
}
DataRow dr = dt.NewRow();
dr["Seriveces"] = txtServices.Text;
dr["Date"] = txtDate.Text;
dr["NoPax"] = txtNoPax.Text;
dr["Supplier"] = drpSupplier.Text;
dr["NetPrice"] = txtNetPrice.Text;
dr["SellPrice"] = txtSellPrice.Text;
dr["From"] = txtFrom.Text;
dr["To"] = txtTo.Text;
dr["NoOfPassanger"] = txtPassenger.Text;
dr["chkAditional"] = chkaditional.Checked;
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
TextBox txtServices = (TextBox)item.FindControl("txtServices");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtNoPax = (TextBox)item.FindControl("txtNoPax");
DropDownList drpSupplier = (DropDownList)item.FindControl("drpSupplier");
TextBox txtNetPrice = (TextBox)item.FindControl("txtNetPrice");
TextBox txtSellPrice = (TextBox)item.FindControl("txtSellPrice");
TextBox txtFrom = (TextBox)item.FindControl("txtFrom");
TextBox txtTo = (TextBox)item.FindControl("txtTo");
TextBox txtPassenger = (TextBox)item.FindControl("txtNoOfPassanger");
CheckBox chkaditional = (CheckBox)item.FindControl("chkAditional");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
txtServices.Text = dt.Rows[itm]["Seriveces"].ToString();
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtNoPax.Text = dt.Rows[itm]["NoPax"].ToString();
drpSupplier.Text = dt.Rows[itm]["Supplier"].ToString();
DataSet dsadditional = objHotelStoreProcedure.fetchComboData("GET_CHAIN_NAME_FOR_ADDITIONAL_SERVICES", "");
binddropdownlist(drpSupplier, dsadditional);
txtNetPrice.Text = dt.Rows[itm]["NetPrice"].ToString(); ;
txtSellPrice.Text = dt.Rows[itm]["SellPrice"].ToString();
txtFrom.Text = dt.Rows[itm]["From"].ToString();
txtTo.Text = dt.Rows[itm]["To"].ToString();
txtPassenger.Text = dt.Rows[itm]["NoOfPassanger"].ToString();
if (dt.Rows[itm]["chkAditional"].ToString() == "True")
{
chkaditional.Checked = true;
}
else
{
chkaditional.Checked = false;
}
}
}
}
if (RoleId != "18")
{
divAddServ.Visible = false;
lbladdservice.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void ReconfirmHotelCheckChanged(GridView gv, UpdatePanel up, object sender)
{
ViewState["Hotel_Name"] = null;
ViewState["Room_Type"] = null;
foreach (GridViewRow item in gv.Rows)
{
RadioButton rb = (RadioButton)item.FindControl("rdoConfirm");
if (rb != sender)
{
rb.Checked = false;
}
if (rb.Checked == true)
{
DropDownList dhotel = (DropDownList)item.FindControl("drpHotelName");
ViewState["Hotel_Name"] = dhotel.Text;
DropDownList drtype = (DropDownList)item.FindControl("drpRoomType");
ViewState["Room_Type"] = drtype.Text;
btnConfirmHotel.Visible = true;
}
}
pnlCompanyRoleSelection.Attributes.Add("style", "display:none");
up.Update();
Updateconfirm.Update();
}
protected void DateValidationofHotel(GridView gv, String city, UpdatePanel uppanel)
{
try
{
GetMinimumDate(gv, city);
GetMaximumDate(gv, city);
for (int i = 0; i < gv.Rows.Count; i++)
{
TextBox txtCheckInDate = (TextBox)gv.Rows[i].FindControl("txtCheckInDate");
TextBox txtCheckOutDate = (TextBox)gv.Rows[i].FindControl("txtCheckOutDate");
DropDownList drpHotelName = (DropDownList)gv.Rows[i].FindControl("drpHotelName");
DropDownList drpRoomType = (DropDownList)gv.Rows[i].FindControl("drpRoomType");
if (i == 0)
{
if ((DateTime.ParseExact(txtCheckInDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(ViewState["minDate"].ToString(), "dd/MM/yyyy", null)))
{
// txtCheckInDate.Text = ViewState["minDate"].ToString();
ViewState["HotelDateMessage"] = drpHotelName.Text + "'s Check in date is not valid at ROW" + " " + (i + 1);
hotelDateFlag = false;
}
}
else
{
if ((DateTime.ParseExact(txtCheckInDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(ViewState["minDate"].ToString(), "dd/MM/yyyy", null)))
{
TextBox txtPreviousCheckOutDate = (TextBox)gv.Rows[i - 1].FindControl("txtCheckOutDate");
if ((DateTime.ParseExact(txtCheckInDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(txtPreviousCheckOutDate.Text, "dd/MM/yyyy", null)))
{
// txtCheckInDate.Text = txtPreviousCheckOutDate.Text;
ViewState["HotelDateMessage"] = drpHotelName.Text + "'s Check in date is not valid at ROW" + " " + (i + 1);
hotelDateFlag = false;
}
}
}
if (i + 1 != gv.Rows.Count)
{
if ((DateTime.ParseExact(txtCheckOutDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(ViewState["maxDate"].ToString(), "dd/MM/yyyy", null)))
{
TextBox txtPreviousCheckInDate = (TextBox)gv.Rows[i + 1].FindControl("txtCheckInDate");
if ((DateTime.ParseExact(txtCheckOutDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(txtPreviousCheckInDate.Text, "dd/MM/yyyy", null)))
{
// txtCheckOutDate.Text = txtPreviousCheckInDate.Text;
ViewState["HotelDateMessage"] = drpHotelName.Text + "'s Check out date is not valid at ROW" + " " + (i + 1);
hotelDateFlag = false;
}
}
}
else
{
if ((DateTime.ParseExact(txtCheckOutDate.Text, "dd/MM/yyyy", null) != DateTime.ParseExact(ViewState["maxDate"].ToString(), "dd/MM/yyyy", null)))
{
// txtCheckOutDate.Text = ViewState["maxDate"].ToString();
ViewState["HotelDateMessage"] = drpHotelName.Text + "'s Check out date is not valid at ROW" + " " + (i + 1);
hotelDateFlag = false;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
// ADD BUTTON FUNCTION
protected void addMeals(GridView gv, string CITY_NAME, UpdatePanel uppanel)
{
try
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
DataSet ds = objGitDetail.fetchResturants("GET_RESTRANTS_NAMES_FOR_GIT", CITY_NAME);
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpResturant = (DropDownList)item.FindControl("drpResturant");
DropDownList drpMealType = (DropDownList)item.FindControl("drpMealType");
CheckBox chkMeal = (CheckBox)item.FindControl("chkMeal");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtVage = (TextBox)item.FindControl("txtVage");
TextBox txtNonVage = (TextBox)item.FindControl("txtNonVag");
TextBox txtJain = (TextBox)item.FindControl("txtJain");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("MealType");
dt.Columns.Add("Resturant");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("Time");
dt.Columns.Add("Veg");
dt.Columns.Add("NonVeg");
dt.Columns.Add("Jain");
}
DataRow dr = dt.NewRow();
dr["Date"] = txtDate.Text;
dr["MealType"] = drpMealType.Text;
dr["Resturant"] = drpResturant.Text;
dr["ChildRate"] = txtChildRate.Text;
dr["AdultRate"] = txtAdultRate.Text;
dr["Time"] = txttime.SelectedDate;
dr["Veg"] = txtVage.Text;
dr["NonVeg"] = txtNonVage.Text;
dr["Jain"] = txtJain.Text;
if (chkMeal.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("MealType");
dt.Columns.Add("Resturant");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
dt.Columns.Add("Time");
dt.Columns.Add("Veg");
dt.Columns.Add("NonVeg");
dt.Columns.Add("Jain");
}
DataRow dr = dt.NewRow();
dr["Date"] = "";
dr["MealType"] = "";
dr["Resturant"] = "";
dr["AddCart"] = "";
dr["ChildRate"] = "";
dr["AdultRate"] = "";
dr["Time"] = "";
dr["Veg"] = "";
dr["NonVeg"] = "";
dr["Jain"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
DropDownList drpResturant = (DropDownList)item.FindControl("drpResturant");
DropDownList drpMealType = (DropDownList)item.FindControl("drpMealType");
CheckBox chkMeal = (CheckBox)item.FindControl("chkMeal");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtVage = (TextBox)item.FindControl("txtVage");
TextBox txtNonVage = (TextBox)item.FindControl("txtNonVag");
TextBox txtJain = (TextBox)item.FindControl("txtJain");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpResturant, ds);
drpResturant.Text = dt.Rows[itm]["Resturant"].ToString();
if (drpResturant.Text != "")
{
DataSet dsMealType = objGitDetail.fetchMealType("GET_MEAL_TYPE_OF_RESTURANTS", drpResturant.Text);
binddropdownlist(drpMealType, dsMealType);
drpMealType.Text = dt.Rows[itm]["MealType"].ToString();
}
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtChildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtAdultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
txtVage.Text = dt.Rows[itm]["Veg"].ToString();
txtNonVage.Text = dt.Rows[itm]["NonVeg"].ToString();
txtJain.Text = dt.Rows[itm]["Jain"].ToString();
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chkMeal.Checked = true;
}
else
{
chkMeal.Checked = false;
}
}
}
}
if (RoleId != "18")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblChildrate = new Label();
Label lblAdultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnMealRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
//gv.Columns[4].Visible = false;
//gv.Columns[5].Visible = false;
}
}
if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
{
Button RateButton = new Button();
TextBox ChildRate = new TextBox();
TextBox AdultRate = new TextBox();
Label lblChildrate = new Label();
Label lblAdultrate = new Label();
for (int i = 0; i < gv.Rows.Count; i++)
{
RateButton = (Button)gv.Rows[i].FindControl("btnMealRate");
RateButton.Visible = false;
ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
ChildRate.Visible = false;
AdultRate.Visible = false;
if (gv.HeaderRow != null)
{
Label lblAdultRate = (Label)gv.HeaderRow.FindControl("lblAdultRate");
lblAdultRate.Visible = false;
Label lblchildRate = (Label)gv.HeaderRow.FindControl("lblchildRate");
lblchildRate.Visible = false;
}
}
}
if (Session["OrderStatus"].ToString() == "To Be Reconfirmed")
{
gv.Columns[6].Visible = true;
gv.Columns[7].Visible = true;
gv.Columns[8].Visible = true;
gv.Columns[9].Visible = true;
btnmealsave.Visible = true;
}
else
{
gv.Columns[6].Visible = false;
gv.Columns[7].Visible = false;
gv.Columns[8].Visible = false;
gv.Columns[9].Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void removeRow(GridView gv, int rowIndex, UpdatePanel uppanel)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
foreach (GridViewRow item in gv.Rows)
{
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
TextBox txtUnitNo = (TextBox)item.FindControl("txtUnitNo");
TextBox txtAPP = (TextBox)item.FindControl("txtAPP");
Label lblDeatilsID = (Label)item.FindControl("lblDeatilsID");
Label lblTotalAmount = (Label)item.FindControl("lblTotalAmount");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Description");
dt.Columns.Add("UnitNo");
dt.Columns.Add("AmountPerPerson");
dt.Columns.Add("TotalAmount");
dt.Columns.Add("DetailID");
}
DataRow dr = dt.NewRow();
dr["Description"] = txtDescription.Text;
dr["UnitNo"] = txtUnitNo.Text;
dr["AmountPerPerson"] = txtAPP.Text;
dr["TotalAmount"] = lblTotalAmount.Text;
dr["DetailID"] = lblDeatilsID.Text;
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
int itm1 = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
TextBox txtUnitNo = (TextBox)item.FindControl("txtUnitNo");
TextBox txtAPP = (TextBox)item.FindControl("txtAPP");
Label lblDeatilsID = (Label)item.FindControl("lblDeatilsID");
Label lblTotalAmount = (Label)item.FindControl("lblTotalAmount");
Button btnHotelRemove = (Button)item.FindControl("btnHotelRemove");
if (ViewState["RowCount"] != null)
{
if (itm <= int.Parse(ViewState["RowCount"].ToString()))
{
btnHotelRemove.Visible = false;
}
else
{
}
}
txtDescription.Text = dt.Rows[itm]["Description"].ToString();
txtUnitNo.Text = dt.Rows[itm]["UnitNo"].ToString();
txtAPP.Text = dt.Rows[itm]["AmountPerPerson"].ToString();
lblDeatilsID.Text = dt.Rows[itm]["DetailID"].ToString();
lblTotalAmount.Text = dt.Rows[itm]["TotalAmount"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void RemoveMeals(GridView gv, string CITY_NAME, UpdatePanel uppanel, int rowIndex)
{
try
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
DataSet ds = objGitDetail.fetchResturants("GET_RESTRANTS_NAMES_FOR_GIT", CITY_NAME);
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpResturant = (DropDownList)item.FindControl("drpResturant");
DropDownList drpMealType = (DropDownList)item.FindControl("drpMealType");
CheckBox chkMeal = (CheckBox)item.FindControl("chkMeal");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("Date");
dt.Columns.Add("MealType");
dt.Columns.Add("Resturant");
dt.Columns.Add("AddCart");
dt.Columns.Add("ChildRate");
dt.Columns.Add("AdultRate");
}
DataRow dr = dt.NewRow();
dr["Date"] = txtDate.Text;
dr["MealType"] = drpMealType.Text;
dr["Resturant"] = drpResturant.Text;
dr["ChildRate"] = txtChildRate.Text;
dr["AdultRate"] = txtAdultRate.Text;
if (chkMeal.Checked)
{
dr["AddCart"] = "True";
}
else
{
dr["AddCart"] = "False";
}
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
DropDownList drpResturant = (DropDownList)item.FindControl("drpResturant");
DropDownList drpMealType = (DropDownList)item.FindControl("drpMealType");
CheckBox chkMeal = (CheckBox)item.FindControl("chkMeal");
TextBox txtDate = (TextBox)item.FindControl("txtDate");
TextBox txtChildRate = (TextBox)item.FindControl("txtChildRate");
TextBox txtAdultRate = (TextBox)item.FindControl("txtAdultRate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
binddropdownlist(drpResturant, ds);
drpResturant.Text = dt.Rows[itm]["Resturant"].ToString();
if (drpResturant.Text != "")
{
DataSet dsMealType = objGitDetail.fetchMealType("GET_MEAL_TYPE_OF_RESTURANTS", drpResturant.Text);
binddropdownlist(drpMealType, dsMealType);
drpMealType.Text = dt.Rows[itm]["MealType"].ToString();
}
txtDate.Text = dt.Rows[itm]["Date"].ToString();
txtChildRate.Text = dt.Rows[itm]["ChildRate"].ToString();
txtAdultRate.Text = dt.Rows[itm]["AdultRate"].ToString();
if (dt.Rows[itm]["AddCart"].ToString() == "True")
{
chkMeal.Checked = true;
}
else
{
chkMeal.Checked = false;
}
}
}
}
//if (RoleId != "18")
//{
// Button RateButton = new Button();
// TextBox ChildRate = new TextBox();
// TextBox AdultRate = new TextBox();
// Label lblchildrate = new Label();
// Label lbladultrate = new Label();
// for (int i = 0; i < gv.Rows.Count; i++)
// {
// RateButton = (Button)gv.Rows[i].FindControl("btnMealRate");
// RateButton.Visible = false;
// ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
// AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
// ChildRate.Visible = false;
// AdultRate.Visible = false;
// gv.Columns[4].Visible = false;
// gv.Columns[5].Visible = false;
// gv.Columns[6].Visible = false;
// }
//}
//if (RoleId == "18" && Session["OrderStatus"].ToString() != "Request for Quote")
//{
// Button RateButton = new Button();
// TextBox ChildRate = new TextBox();
// TextBox AdultRate = new TextBox();
// Label lblchildrate = new Label();
// Label lbladultrate = new Label();
// for (int i = 0; i < gv.Rows.Count; i++)
// {
// RateButton = (Button)gv.Rows[i].FindControl("btnMealRate");
// RateButton.Visible = false;
// ChildRate = (TextBox)gv.Rows[i].FindControl("txtAdultRate");
// AdultRate = (TextBox)gv.Rows[i].FindControl("txtChildRate");
// ChildRate.Visible = false;
// AdultRate.Visible = false;
// gv.Columns[4].Visible = false;
// gv.Columns[5].Visible = false;
// gv.Columns[6].Visible = false;
// }
//}
}
catch (Exception ex)
{
throw ex;
}
finally
{
uppanel.Update();
}
}
protected void AddTransferDetails(GridView gv, UpdatePanel uppanel)
{
int count = gv.Rows.Count;
int count1 = count + 1;
DataTable dt = new DataTable();
// DataSet ds = objGitDetail.fetchComboDataforHotel("FETCH_HOTEL_NAME_FOR_GIT_CITY_WISE", CityName, "01/09/2012", "11/09/2012");
foreach (GridViewRow item in gv.Rows)
{
DropDownList drpFrom = (DropDownList)item.FindControl("drpFrom");
DropDownList drpTo = (DropDownList)item.FindControl("drpTo");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("From");
dt.Columns.Add("To");
}
DataRow dr = dt.NewRow();
dr["From"] = drpFrom.Text;
dr["To"] = drpTo.Text;
dt.Rows.Add(dr);
}
if (count == 0)
{
if (dt.Columns.Count == 0)
{
dt.Columns.Add("From");
dt.Columns.Add("To");
}
DataRow dr = dt.NewRow();
dr["From"] = "";
dr["To"] = "";
dt.Rows.Add(dr);
gv.DataSource = dt;
gv.DataBind();
uppanel.Update();
}
if (count != 0)
{
DataRow dr1 = dt.NewRow();
dt.Rows.Add(dr1);
}
gv.DataSource = dt;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
DropDownList drpFrom = (DropDownList)item.FindControl("drpFrom");
DropDownList drpTo = (DropDownList)item.FindControl("drpTo");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
DataSet ds = objTransportPriceListGIT.fetchComboData("FETCH_ALL_TRANSFER_PACKAGE_NAME_AUTOSERACH");
binddropdownlist(drpFrom, ds);
binddropdownlist(drpTo, ds);
drpFrom.Text = dt.Rows[itm]["From"].ToString();
drpTo.Text = dt.Rows[itm]["To"].ToString();
}
}
}
uppanel.Update();
}
protected void RemoveDeparture(GridView gv, UpdatePanel uppanel, int rowIndex)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
int count = gv.Rows.Count;
for (int i = 0; i < count - 1; i++)
{
dt1.Rows.Add();
}
foreach (GridViewRow item in gv.Rows)
{
TextBox txtDepartureFlightName = (TextBox)item.FindControl("txtFlightName");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtNoOfPassenger = (TextBox)item.FindControl("txtNoOfPassenger");
TextBox txtdate = (TextBox)item.FindControl("txtFlightDate");
if (dt.Columns.Count == 0)
{
dt.Columns.Add("FlightName");
dt.Columns.Add("Time");
dt.Columns.Add("NoOfPassenger");
dt.Columns.Add("Date");
}
DataRow dr = dt.NewRow();
dr["FlightName"] = txtDepartureFlightName.Text;
dr["Time"] = txttime.SelectedDate;
dr["NoOfPassenger"] = txtNoOfPassenger.Text;
dr["Date"] = txtdate.Text;
dt.Rows.Add(dr);
}
gv.DataSource = dt1;
gv.DataBind();
foreach (GridViewRow item in gv.Rows)
{
int itm = item.DataItemIndex;
if (itm >= rowIndex)
{
itm = itm + 1;
}
TextBox txtDepartureFlightName = (TextBox)item.FindControl("txtFlightName");
RadTimePicker txttime = (RadTimePicker)item.FindControl("rdtpTime");
TextBox txtNoOfPassenger = (TextBox)item.FindControl("txtNoOfPassenger");
TextBox txtdate = (TextBox)item.FindControl("txtFlightDate");
for (int k = 0; k < dt.Rows.Count; k++)
{
if (itm == k)
{
txtDepartureFlightName.Text = dt.Rows[itm]["FlightName"].ToString();
if (dt.Rows[itm]["Time"].ToString() != "")
{
txttime.SelectedDate = DateTime.Parse(dt.Rows[itm]["Time"].ToString());
}
txtNoOfPassenger.Text = dt.Rows[itm]["NoOfPassenger"].ToString();
txtdate.Text = dt.Rows[itm]["Date"].ToString();
}
}
}
uppanel.Update();
}
