protected void btnGetDeatils_Click(object sender, EventArgs e)
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetAvailableSeatsDetails(Convert.ToInt32(txtSessionId.Text.Trim()), ViewState["action"].ToString());
if (ds != null && ds.Tables.Count > 0)
{
lblCounter.Text = ds.Tables[0].Rows[0]["CounterName"].ToString();
lblSource.Text = ds.Tables[0].Rows[0]["Source"].ToString();
lblDes.Text = ds.Tables[0].Rows[0]["Destination"].ToString();
lblMode.Text = ds.Tables[0].Rows[0]["Mode"].ToString();
lblDate.Text = ds.Tables[0].Rows[0]["Schd_Date"].ToString();
lblFare.Text = ds.Tables[0].Rows[0]["Fare"].ToString();
if (ds.Tables.Count > 1)
{
ddlSeats.Items.Clear();
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
ddlSeats.Items.Add(ds.Tables[1].Rows[i][0].ToString());
}
}
}
}
}
protected void btnReleaseSession_Click(object sender, EventArgs e)
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.BlockSeat(Convert.ToInt32(txtSessionId.Text.Trim()), "", 0, "E");
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "succcess")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Selected Session is enabled successfully. ')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session is not enabled, please try again.')", true);
}
}
txtSessionId.Text = "";
lblCounter.Text = "";
lblSource.Text = "";
lblDes.Text = "";
lblMode.Text = "";
lblDate.Text = "";
lblFare.Text = "";
ddlSeats.Items.Clear();
UpdatePanel1.Update();
}
public string AddCarRentalDetails(CarRentalEntity obj)
{
string tranid = "";
DALSchedule objSchedule = new DALSchedule();
tranid = objSchedule.AddCarRentalDeatails(obj);
return(tranid);
}
protected void btnExport_Click(object sender, EventArgs e)
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetSoldTicketsList("Shared");
ExportTableData(dt);
dt = null;
}
void fillgrid()
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetSoldTicketsList("Shared");
grdSoldTickets.DataSource = dt;
grdSoldTickets.DataBind();
}
protected void BindRepeaterData()
{
DALSchedule objDAL = new DALSchedule();
DataTable dt = objDAL.GetFranchiseeList("");
RepSample.DataSource = dt;
RepSample.DataBind();
objDAL = null;
dt = null;
}
public int CreateSchedule(Scheduling obj)
{
try
{
DALSchedule objSch = new DALSchedule();
objSch.CreateSchedule(obj);
return(1);
}
catch (Exception)
{
throw;
}
}
public int AddVehicle(Vehicle obj)
{
try
{
DALSchedule objSchedule = new DALSchedule();
objSchedule.AddVehicle(obj);
return(1);
}
catch (Exception)
{
throw;
}
}
public string AddCashDetails(CashDetails obj)
{
try
{
DALSchedule objSchedule = new DALSchedule();
string tranid = objSchedule.AddCashDeatails(obj).ToString();
//return 1;
return(tranid);
}
catch (Exception)
{
throw;
}
}
public DataTable GetTicketInfo(string tranid, string mobno)
{
try
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetTicketInfo(tranid, mobno);
return(dt);
}
catch (Exception)
{
throw;
}
}
public string AddEventBookingDetails(string name, string gender, int age, string email, string mob, string address, int stagboy, int staggirl, int couple, int child, decimal bookingAmt)
{
try
{
string tranid = "";
DALSchedule objSchedule = new DALSchedule();
tranid = objSchedule.AddEventBookingDetails(name, gender, age, email, mob, address, stagboy, staggirl, couple, child, bookingAmt, out tranid);
return(tranid);
}
catch (Exception)
{
throw;
}
}
public DataSet GetSchedule(string from, string to, string mode, string dt)
{
try
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetSchedule(from, to, mode, dt);
return(ds);
}
catch (Exception)
{
throw;
}
}
public DataTable GetCarRentalScheduleDetails(int session_id)
{
try
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetCarRentalScheduleDetails(session_id);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataSet GetScheduleInfo(int sessionid, string mode)
{
try
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetScheduleInfo(sessionid, mode);
return(ds);
}
catch (Exception)
{
throw;
}
}
public DataSet GetTravellingInfo(string src, string des, int sid)
{
try
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetTravellingInfo(src, des, sid);
return(ds);
}
catch (Exception)
{
throw;
}
}
//***********CarRentalDataAccessLib*********************************
public DataTable GetCarRentalSchedule(string travel_type, string Source_city, string Destination_city, string travel_mode)
{
try
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetCarRentalSchedule(travel_type, Source_city, Destination_city, travel_mode);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable GetLoginInfo(string username, string pwd)
{
try
{
DALSchedule obj = new DALSchedule();
DataTable dt = obj.GetLoginInfo(username, pwd);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataSet GetBoardingPoints(int session_id)
{
try
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetBoardingPoints(session_id);
return(ds);
}
catch (Exception)
{
throw;
}
}
public DataTable CancelTicket(TicketCancel obj)
{
try
{
DALSchedule objSch = new DALSchedule();
DataTable dt = objSch.CancelTicket(obj);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable UpdateUserCashDetails(TPSLResponse obj)
{
try
{
DALSchedule objSch = new DALSchedule();
DataTable dt = objSch.UpdateUserCashDetails(obj);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable PaymentUpdateBMETWallet(string tranid)
{
try
{
DALSchedule objSch = new DALSchedule();
DataTable dt = objSch.PaymentUpdateBMETWallet(tranid);
return(dt);
}
catch (Exception)
{
throw;
}
}
protected void btnTimeChange_Click(object sender, EventArgs e)
{
DALSchedule obj = new DALSchedule();
DataSet ds = obj.GetAvailableSeatsDetails(Convert.ToInt32(txtTime.Text.Trim()), "C");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows[0][0].ToString() == "Success")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Schedule display time is chnaged successfully. ')", true);
}
}
txtTime.Text = "";
}
public DataTable GetFranchiseeDetails(string FranCode, int sessionid, string mode)
{
try
{
DALSchedule objSch = new DALSchedule();
DataTable dt = objSch.GetFranchiseeDetails(FranCode, sessionid, mode);
return(dt);
}
catch (Exception)
{
throw;
}
}
protected void ddlFranCity_SelectedIndexChanged(object sender, EventArgs e)
{
DALSchedule objDAL = new DALSchedule();
DataTable dt = null;
if (ddlFranCity.SelectedItem.Text.ToString() == "-------Select--------")
{
dt = objDAL.GetFranchiseeList("");
}
else
{
dt = objDAL.GetFranchiseeList(ddlFranCity.SelectedItem.Text.ToString());
}
RepSample.DataSource = dt;
RepSample.DataBind();
objDAL = null;
dt = null;
}
public List <BLLSchedule> Selectschedulebyrollno(BLLSchedule objbll)
{
DALSchedule objdal = new DALSchedule();
return(objdal.Selectschedulebyrollno(objbll));
}
public List <BLLSchedule> Selectschedulebyempcode(BLLSchedule objbll)
{
DALSchedule objdal = new DALSchedule();
return(objdal.Selectschedulebyempcode(objbll));
}
public List <BLLSchedule> SelectSchedule()
{
DALSchedule objdal = new DALSchedule();
return(objdal.SelectSchedule());
}
public int InsertSchedule(BLLSchedule objbll)
{
DALSchedule objdal = new DALSchedule();
return(objdal.InsertSchedule(objbll));
}
