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)); }