protected void GridOpenDates_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Select")
{
ViewState["flag"] = "1";
LinkButton lnk = (LinkButton)e.CommandSource;
GridViewRow grow = (GridViewRow)lnk.NamingContainer;
int id = Convert.ToInt32(GridOpenDates.DataKeys[grow.RowIndex].Value);
hfid.Value = id.ToString();
blOpenDates._Action = "GetOpenDatesbyId";
blOpenDates.Id = id;
dtGetReturnedData = new DataTable();
dtGetReturnedData = dlOpenDates.getOpenDatesbyId(blOpenDates);
if (dtGetReturnedData != null)
{
bindrivers(Convert.ToInt32(dtGetReturnedData.Rows[0]["CountryId"].ToString()));
sethiddenfieldnights(dtGetReturnedData.Rows[0]["packageId"].ToString());
txtBoardingDate.Text = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckInDate"]).ToString("MM/dd/yyyy");
txtDeBordingDate.Text = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckOutDate"]).ToString("MM/dd/yyyy");
ddlAccom.SelectedValue = dtGetReturnedData.Rows[0]["AccomId"].ToString();
ddlCountry.SelectedValue = dtGetReturnedData.Rows[0]["CountryId"].ToString();
ddlpackage.SelectedValue = dtGetReturnedData.Rows[0]["packageId"].ToString();
ddlRiver.SelectedValue = dtGetReturnedData.Rows[0]["RiverId"].ToString();
btnAdd.Text = "Update";
}
else
{
txtBoardingDate.Text = "";
txtDeBordingDate.Text = "";
ddlAccom.SelectedIndex = 0;
ddlCountry.SelectedIndex = 0;
ddlpackage.SelectedIndex = 0;
ddlRiver.SelectedIndex = 0;
}
}
if (e.CommandName == "Open")
{
int getid = Convert.ToInt32(e.CommandArgument.ToString());
blOpenDates.Id = getid;
blOpenDates._Action = "GetOpenDatesbyId";
DataTable dt = dlOpenDates.getOpenDatesbyId(blOpenDates);
DataTable getavialabl = bindroomddl(getid, dt.Rows[0]["packageId"].ToString());
DataView dv = new DataView();
dv = new DataView(getavialabl, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
DataTable dt2 = dv.ToTable();
bool check = Convert.ToBoolean(dt.Rows[0]["Openclose"]);
if (dt2 != null && dt2.Rows.Count > 0 && check != true)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Close can only happen if there is no booking on those departures')", true);
return;
}
else
{
blsr.action = "getchilid";
blsr.PackageId = dt.Rows[0]["packageId"].ToString();
DataTable dtchild = dlsr.getchilid(blsr);
if (dtchild != null && dtchild.Rows.Count > 0)
{
for (int i = 0; i < dtchild.Rows.Count; i++)
{
blsr.action = "getdepartureid";
blsr.PackageId = dtchild.Rows[i]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
if (dtgetdepurtureid != null && dtgetdepurtureid.Rows.Count > 0)
{
blsr.action = "GetcruiseRooms";
blsr.DepartureId = Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString());
DataTable dtgetchild = dlsr.GetCruiseRooms(blsr);
DataView dvgetchild = new DataView();
dvgetchild = new DataView(dtgetchild, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
dtgetchild = dvgetchild.ToTable();
if (dtgetchild != null && dtgetchild.Rows.Count > 0)
{
Session["set"] = null;
}
else
{
Session["set"] = 1;
}
}
else
{
Session["set"] = 1;
}
}
}
else
{
blsr.action = "getdepartureid";
blsr.PackageId = dt.Rows[0]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
if (dtgetdepurtureid != null && dtgetdepurtureid.Rows.Count > 0)
{
blsr.action = "GetcruiseRooms";
blsr.DepartureId = Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString());
DataTable dtgetchild = dlsr.GetCruiseRooms(blsr);
DataView dvgetchild = new DataView();
dvgetchild = new DataView(dtgetchild, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
dtgetchild = dvgetchild.ToTable();
if (dtgetchild != null && dtgetchild.Rows.Count > 0)
{
Session["set"] = null;
}
else
{
Session["set"] = 1;
}
}
}
if (Session["set"] != null || check == true)
{
int n = dalp.updateopenclose(getid);
if (n == 1)
{
for (int i = 0; i < dtchild.Rows.Count; i++)
{
blsr.action = "getdepartureid";
blsr.PackageId = dtchild.Rows[i]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
try
{
int n1 = dalp.updateopenclosebydate(Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString()));
if (n1 == 1)
{
}
}
catch (Exception ex) { }
}
Session["set"] = null;
Button1_Click(this, e);
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Update Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Please try again')", true);
return;
}
}
}
}
<< << << < HEAD
== == == =
if (e.CommandName == "Open")
{
int getid = Convert.ToInt32(e.CommandArgument.ToString());
blOpenDates.Id = getid;
blOpenDates._Action = "GetOpenDatesbyId";
DataTable dt = dlOpenDates.getOpenDatesbyId(blOpenDates);
DataTable getavialabl = bindroomddl(getid, dt.Rows[0]["packageId"].ToString());
DataView dv = new DataView();
dv = new DataView(getavialabl, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
DataTable dt2 = dv.ToTable();
bool check = Convert.ToBoolean(dt.Rows[0]["Openclose"]);
if (dt2 != null && dt2.Rows.Count > 0 && check != true)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Close can only happen if there is no booking on those departures')", true);
return;
}
else
{
blsr.action = "getchilid";
blsr.PackageId = dt.Rows[0]["packageId"].ToString();
DataTable dtchild = dlsr.getchilid(blsr);
if (dtchild != null && dtchild.Rows.Count > 0)
{
for (int i = 0; i < dtchild.Rows.Count; i++)
{
blsr.action = "getdepartureid";
blsr.PackageId = dtchild.Rows[i]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
if (dtgetdepurtureid != null && dtgetdepurtureid.Rows.Count > 0)
{
blsr.action = "GetcruiseRooms";
blsr.DepartureId = Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString());
DataTable dtgetchild = dlsr.GetCruiseRooms(blsr);
DataView dvgetchild = new DataView();
dvgetchild = new DataView(dtgetchild, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
dtgetchild = dvgetchild.ToTable();
if (dtgetchild != null && dtgetchild.Rows.Count > 0)
{
Session["set"] = null;
}
else
{
Session["set"] = 1;
}
}
}
}
else
{
blsr.action = "getdepartureid";
blsr.PackageId = dt.Rows[0]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
if (dtgetdepurtureid != null && dtgetdepurtureid.Rows.Count > 0)
{
blsr.action = "GetcruiseRooms";
blsr.DepartureId = Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString());
DataTable dtgetchild = dlsr.GetCruiseRooms(blsr);
DataView dvgetchild = new DataView();
dvgetchild = new DataView(dtgetchild, "BookedStatus='Not Available'", "BookedStatus", DataViewRowState.CurrentRows);
dtgetchild = dvgetchild.ToTable();
if (dtgetchild != null && dtgetchild.Rows.Count > 0)
{
Session["set"] = null;
}
else
{
Session["set"] = 1;
}
}
}
if (Session["set"] != null)
{
int n = dalp.updateopenclose(getid);
if (n == 1)
{
for (int i = 0; i < dtchild.Rows.Count; i++)
{
blsr.action = "getdepartureid";
blsr.PackageId = dtchild.Rows[i]["PackageId"].ToString();
blsr._dtStartDate = Convert.ToDateTime(dt.Rows[0]["CheckInDate"].ToString());
blsr._dtEndDate = Convert.ToDateTime(dt.Rows[0]["CheckOutDate"].ToString());
DataTable dtgetdepurtureid = dlsr.getdepartureid(blsr);
try
{
int n1 = dalp.updateopenclosebydate(Convert.ToInt32(dtgetdepurtureid.Rows[0]["Id"].ToString()));
if (n1 == 1)
{
}
}
catch (Exception ex) { }
}
Session["set"] = null;
Button1_Click(this, e);
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Update Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "QuoteFull", "javascript:alert('Please try again')", true);
return;
}
}
}
}