public get_Train_By_ID_Result get_Train_By_IDDAL(int id) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.get_Train_By_ID(id).FirstOrDefault(); } }
public Get_User_By_UserName_v2_Result Get_User_By_UserNameDAL(string username) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.Get_User_By_UserName_v2(username).FirstOrDefault(); } }
public get_Passenger_By_PNR_Result Get_Passenger_By_PNRDAL(string pnr) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.get_Passenger_By_PNR(pnr).FirstOrDefault(); } }
//public IEnumerable<Get_Coach_By_Train_ID_Result> Get_Coach_By_TrainDAL(int idtrain) //{ // using (var orr = new Online_Railway_reservation_systemEntities()) // { // orr.Configuration.ProxyCreationEnabled = false; // foreach (var item in orr.Get_Coach_By_Train_ID(idtrain)) // { // yield return item; // } // } //} public IEnumerable<Search_Coach_Type_Result> Search_CoachDAL(int trainid, string coachtype) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Search_Coach_Type(trainid,coachtype)) { yield return item; } } }
public IEnumerable<get_Passenger_By_Email_Result> Get_Passenger_By_EmailDAL(string email, string phonenumber) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.get_Passenger_By_Email(email, phonenumber)) { yield return item; } } }
public IEnumerable<Search_Ticket_By_PNR_Result> Search_Ticket_By_PNRDAL(string pnr) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Search_Ticket_By_PNR(pnr)) { yield return item; } } }
public IEnumerable<Get_All_Train_v2_Result> Get_All_Trains_v2_DAL() { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Get_All_Train_v2()) { yield return item; } } }
public IEnumerable<getAll_Passengers_Result> GetAll_PassengersDAL() { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.getAll_Passengers()) { yield return item; } } }
public IEnumerable<Get_Coach_By_Train_ID_Result> GetCoachByTrainIDDAL(int trainid) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Get_Coach_By_Train_ID(trainid)) { yield return item; } } }
public int Update_StationsDAL(Station s) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Stations(s.Station_ID,s.Station_Name,s.Latitude,s.Longtitude,s.Status); return 1; } } catch (Exception) { return 0; } }
public int Update_TicketsDAL(Ticket t) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Tickets(t.Ticket_ID, t.PNR, t.Passenger_type, t.Status, t.Train_ID,t.Departure_Date,t.Departure_Time,t.Coach_Type,t.Price); return 1; } } catch (Exception) { return 0; } }
public int Add_RolesDAL(string rolename) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Add_Roles(rolename); return 1; } } catch (Exception) { return 0; } }
public int Update_UsersDAL(User u) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Users(u.Username, u.Password, u.Email, u.Phone_Number, u.Gender, u.Security_Code, u.Role_ID); return 1; } } catch (Exception) { return 0; } }
public int Update_PassengersDAL(Passenger p) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Passengers(p.PNR, p.Passenger_Name, p.Date_Of_Birth, p.Card_Code, p.Gender, p.Email, p.Phone_Number, p.Address); return 1; } } catch (Exception) { return 0; } }
public int Delete_TrainsDAL(int id) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Delete_Trains(id); return 1; } } catch (Exception) { return 0; } }
public int Delete_PassengersDAL(string pnr) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Delete_Passengers(pnr); return 1; } } catch (Exception) { return 0; } }
public int Update_TrainsDAL(Train t) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Trains(t.Train_ID, t.Train_Name, t.Origin_Station_ID, t.Destination_Station_ID, t.Status, t.Train_Type); return 1; } } catch (Exception) { return 0; } }
public int Update_TimetablesDAL(Timetable t) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Timetables(t.Timetable_ID, t.Departure_Date, t.Departure_Time, t.Arrival_Date, t.Arrival_Time, t.Distance, t.Train_ID); return 1; } } catch (Exception) { return 0; } }
public int Add_CoachesDAL(Coach c) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Add_Coaches(c.Coach_Type,c.Train_ID,c.Number_Of_Seats,c.Price,c.Status); return 1; } } catch (Exception) { return 0; } }
public int Update_RolesDAL(Role r) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Roles(r.Role_ID,r.Role_Name); return 1; } } catch (Exception) { return 0; } }
public IEnumerable<Get_Train_By_Time_Sche2_Result> Get_Train_Time_ScheDAL(int id,DateTime dt) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Get_Train_By_Time_Sche2(id,dt)) { yield return item; } } }
public int Update_PasswordDAL(User user) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Password(user.Username, user.Password); return 1; } } catch (Exception) { return 0; } }
public int Search_UsernameDAL(User user) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Search_Username_By_ID(user.Username); return 1; } } catch (Exception) { return 0; } }
public Search_Train_By_Train_id_Result Search_Train_By_Train_id_DAL(int train_id) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.Search_Train_By_Train_id(train_id).FirstOrDefault(); } }
public IEnumerable<Search_Train_TimeTable_Result> search_Train_By_StatinIDDAL(int OSID, int DSID, DateTime DD) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; foreach (var item in orr.Search_Train_TimeTable(OSID, DSID, DD)) { yield return item; } } }
public int Cancel_TicketDAL(int id, string status) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.Cancel_Ticket(id, status); } } catch (Exception) { return 0; } }
public int Update_InfoDAL(User user) { try { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; orr.Update_Info(user.Username, user.Email, user.Phone_Number, user.Gender); return 1; } } catch (Exception) { return 0; } }
public login_Result LoginDAL(string username, string pass) { using (var orr = new Online_Railway_reservation_systemEntities()) { orr.Configuration.ProxyCreationEnabled = false; return orr.login(username, pass).FirstOrDefault(); } }
public Get_Station_By_Train_ID_Result Get_Station_By_Train_IDDAL(int Train_id) { using (var oor = new Online_Railway_reservation_systemEntities()) { oor.Configuration.ProxyCreationEnabled = false; return oor.Get_Station_By_Train_ID(Train_id).FirstOrDefault<Get_Station_By_Train_ID_Result>(); } }