public static List <TravelingDriver> GetTravelNotAttached(int id) { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { var travelingsD = db.TravelingDrivers.Where(t => t.DriverId == id).ToList(); List <TravelingDriver> travelingDNotReg = new List <TravelingDriver>(); var q = db.Registerations.Where(w => w.TravelingDriver.Driver.Id == id).Select(t => t.TravelingDriver).ToList(); foreach (var t in travelingsD) { var travelInReg = q.Where(r => r.TravelingIdDriver == t.TravelingIdDriver).FirstOrDefault(); if (travelInReg == null) { travelingDNotReg.Add(t); } } if (travelingDNotReg == null) { return(null); } return(travelingDNotReg); } } catch (Exception e) { throw new Exception("error"); } }
private static bool IsRangAvailable(TravelingDriver travelingDriver, TravelingPassenger travelingPassenger) { TimeSpan timeSpan = travelingPassenger.ToDate.Date - travelingPassenger.FromDate.Date; int range = timeSpan.Days; bool isAvailable = true; DateTime date = travelingPassenger.FromDate; try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { for (int i = 0; i < range; i++) { if (travelingPassenger.Weekday.Contains(((int)date.DayOfWeek + 1).ToString())) { var q = db.TravelDriverRanges.ToList().Where(w => w.Id == travelingDriver.TravelingIdDriver && w.Date.Date == date.Date).ToList(); if (q.Count != 0) { if (q.First().NumSeatsAvailable <= 0) { isAvailable = false; } } } } } } catch (Exception e) { throw new Exception("error"); } return(isAvailable); }
public static bool UpdateTraveling(TravelingPassenger traveling) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.TravelingPassengers.FirstOrDefault(w => w.TravelingIdPassenger == traveling.TravelingIdPassenger); if (q == null) { return(false); } q.PassengerId = traveling.PassengerId; q.Weekday = traveling.Weekday; q.Places = traveling.Places; q.FromTime = traveling.FromTime; q.ToTime = traveling.ToTime; q.FromDate = traveling.FromDate; q.ToDate = traveling.ToDate; q.Price = traveling.Price; q.Source = traveling.Source; q.Destination = traveling.Destination; q.LatS = traveling.LatS; q.LngS = traveling.LngS; q.LatD = traveling.LatD; q.LngD = traveling.LngD; ctx.SaveChanges(); return(true); } } catch { throw; } }
public static List <int> GetGender() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { List <int> genderList = new List <int>(); int female = 0, male = 0; foreach (var item in db.Users.ToList()) { if (item.Gender == true) { male++; } else { female++; } } genderList.Add(female); genderList.Add(male); return(genderList); } } catch (Exception e) { throw new Exception("error"); } }
public static void AddPaymentCancelToP(Registeration registeration, DateTime fromDate, DateTime toDate) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { if (registeration == null) { return; } TravelingPassenger traveling = ctx.TravelingPassengers.FirstOrDefault(d => d.TravelingIdPassenger == registeration.TravelingIdPassenger); if (traveling == null) { return; } Payment payment = new Payment() { IdPaymentKind = 3, PaymentDate = DateTime.Now, SumPay = traveling.Price }; payment.Registeration = registeration; payment.IdRegisteration = registeration.Id; ctx.Payments.Add(payment); ctx.SaveChanges(); } } catch { throw; } }
public static bool UpdateUser(User user, string id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.Users.FirstOrDefault(w => w.Identity.CompareTo(id) == 0); if (q == null) { return(false); } q.Name = user.Name; q.Mail = user.Mail; q.Gender = user.Gender; q.Cellphone = user.Cellphone; q.CreditCardNumber = user.CreditCardNumber; q.Validity = user.Validity; q.Cvv = user.Cvv; q.IdCardOwner = user.IdCardOwner; ctx.SaveChanges(); return(true); } } catch { throw; } }
public static void AddRegisteration(Registeration registeration) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { TravelingDriver travelingDriver = ctx.TravelingDrivers.FirstOrDefault(w => w.TravelingIdDriver == registeration.TravelingIdDriver); TravelingPassenger travelingPassenger = ctx.TravelingPassengers.FirstOrDefault(w => w.TravelingIdPassenger == registeration.TravelingIdPassenger); registeration.TravelingDriver = travelingDriver; registeration.TravelingPassenger = travelingPassenger; travelingPassenger.IsEmbedded = true; TimeSpan timeSpan = registeration.TravelingPassenger.ToDate - registeration.TravelingPassenger.FromDate; int range = timeSpan.Days; DateTime date = registeration.TravelingPassenger.FromDate; TimeSpan ts = new TimeSpan(registeration.TravelingDriver.Time.Hours, registeration.TravelingDriver.Time.Minutes, registeration.TravelingDriver.Time.Seconds); date = date + ts; Registeration newRegisteration = new Registeration() { TravelingIdDriver = registeration.TravelingIdDriver, TravelingIdPassenger = registeration.TravelingIdPassenger, Date = DateTime.Now, TravelingDriver = travelingDriver, TravelingPassenger = travelingPassenger }; ctx.Registerations.Add(newRegisteration); ctx.SaveChanges(); //לולאה על כל טווח הנסיעה for (int i = 0; i < range; i++) { if (registeration.TravelingPassenger.Weekday.Contains(((int)date.DayOfWeek + 1).ToString())) { var q = ctx.TravelDriverRanges.FirstOrDefault(t => t.Id == travelingDriver.TravelingIdDriver && t.Date == date.Date); q.NumSeatsAvailable = q.NumSeatsAvailable - 1; RegistrationDateRange registrationDateRange = new RegistrationDateRange() { Id = newRegisteration.Id, DateInRange = date, IsActive = true, IsComplain = false, NumComplainants = 0, NumPassengers = 1 }; registrationDateRange.Registeration = newRegisteration; ctx.RegistrationDateRanges.Add(registrationDateRange); ctx.SaveChanges(); } date = date.AddDays(1); } } } catch { throw; } }
public static void AddPassenger(Passenger passenger) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { ctx.Passengers.Add(passenger); ctx.SaveChanges(); } } catch { throw; } }
public static List <RegistrationDateRange> GetRegisterationDates() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { return(db.RegistrationDateRanges.ToList()); } } catch (Exception e) { throw new Exception("error"); } }
public static List <TravelDriverRange> GetTravelRanges() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { return(db.TravelDriverRanges.ToList()); } } catch (Exception e) { throw new Exception("error"); } }
public static List <User> GetUsers() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { return(db.Users.ToList()); } } catch (Exception e) { throw new Exception("error"); } }
public static List <Passenger> GetPassengers() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { return(db.Passengers.Include("Users").ToList()); } } catch (Exception e) { throw new Exception("error"); } }
public static int AddTraveling(TravelingPassenger traveling) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { Passenger passenger = ctx.Passengers.FirstOrDefault(w => w.Id == traveling.PassengerId); traveling.Passenger = passenger; ctx.TravelingPassengers.Add(traveling); ctx.SaveChanges(); return(traveling.TravelingIdPassenger); } } catch { throw; } }
public static Registeration GetRegisterationByPassengerId(int id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.Registerations.FirstOrDefault(w => w.TravelingIdPassenger == id); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static TravelingPassenger GetTraveling(int id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.TravelingPassengers.FirstOrDefault(w => w.TravelingIdPassenger == id); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static List <TravelingPassenger> GetTravelSuitableP(TravelingDriver travelingDriver) { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { List <TravelingPassenger> matchPassengers = db.TravelingPassengers.ToList() .Where(w => w.IsEmbedded == false && w.IsActive == true && isSuitibale(w, travelingDriver) == true).ToList(); return(matchPassengers); } } catch (Exception e) { throw new Exception("error"); } }
public static TravelReporting GetTravelReport(int travelingIdDriver, DateTime dateInRange) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.TravelReportings.FirstOrDefault(w => w.IdTravelingDriver == travelingIdDriver && w.Date.Date == dateInRange.Date); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static Payment AddPayment(Payment payment) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { ctx.Payments.Add(payment); ctx.SaveChanges(); } return(payment); } catch (Exception e) { return(new Payment()); } }
public static List <RegistrationDateRange> GetDateByRegistrationId(int id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.RegistrationDateRanges.Where(w => w.Registeration.Id == id).ToList(); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static List <RegistrationDateRange> GetRegisterationNow(TravelDriverRange travelDriver) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.RegistrationDateRanges.ToList().Where(w => w.Registeration.TravelingIdDriver == travelDriver.Id && w.DateInRange.Date == travelDriver.Date.Date).ToList(); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static List <RegistrationDateRange> GetTravelingsNow() { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { List <RegistrationDateRange> registerations = ctx.RegistrationDateRanges.ToList().Where(w => isNow(w) == true).ToList(); if (registerations.Count == 0) { return(null); } return(registerations); } } catch { throw; } }
public static RegistrationDateRange GetDate(int id, DateTime date) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.RegistrationDateRanges.FirstOrDefault(w => w.Id == id && w.DateInRange.Date == date.Date); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static TravelDriverRange GetTravelRange(int id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.TravelDriverRanges.FirstOrDefault(w => w.Identity == id); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static List <Registeration> GetRegisterationByDriverId(int id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.Registerations.Where(w => w.TravelingIdDriver == id).ToList(); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static int GetAvgPassengers() { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { int count = db.TravelingDrivers.Count(p => p.Price >= 0); int sum = db.TravelingDrivers.Where(x => x.Price >= 0).Sum(p => (int)p.Price); return(sum / count); } } catch (Exception e) { throw new Exception("error"); } }
public static List <Payment> GetPaymentsD(int id) { try { using (Travel_In_GroupDBEntities db = new Travel_In_GroupDBEntities()) { return(db.Payments.Where(p => p.Registeration.TravelingDriver.DriverId == id).ToList()); } } catch (Exception e) { return(null); throw new Exception("error"); } }
public static Driver GetDriver(string id) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.Drivers.FirstOrDefault(w => w.Identity == id); if (q == null) { return(null); } return(q); } } catch { throw; } }
public static void StatusComplain(int id, DateTime dateInRange) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.RegistrationDateRanges.FirstOrDefault(w => w.Id == id && w.DateInRange == dateInRange); if (q == null) { return; } q.IsComplain = true; ctx.SaveChanges(); } } catch { throw; } }
public static void UpdatePay(int idTravelingDriver, DateTime date) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { var q = ctx.TravelReportings.FirstOrDefault(w => w.IdTravelingDriver == idTravelingDriver && w.Date.Date == date.Date); if (q == null) { return; } q.IsPay = true; ctx.SaveChanges(); } } catch { throw; } }
public static void AddDriver(Driver driver) { try { using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities()) { User user = ctx.Users.FirstOrDefault(w => w.Identity.CompareTo(driver.Identity) == 0); driver.User = user; ctx.Drivers.Add(driver); ctx.SaveChanges(); } } catch (Exception e) { throw; } }