private bool Update(SubscriptionFlights item) { try { using (SqlConnection db = new SqlConnection()) { var record = db.SubscriptionFlights.FirstOrDefault(t => t.Id == item.Id); record.Id = item.Id; record.FlightId = item.FlightId; record.UserId = item.UserId; record.Created = item.Created; db.SaveChanges(); } Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsRepo.Update", "Flight was successfully updated"); return(true); } catch (Exception e) { Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace); return(false); } }
private int Insert(SubscriptionFlights item) { try { using (SqlConnection db = new SqlConnection()) { db.SubscriptionFlights.Add(item); db.SaveChanges(); } Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsRepo.Insert", $"Flight was successfully inserted"); return(item.Id); } catch (Exception e) { Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace); return(0); } }
private SubscriptionFlights SelectItem(int id) { try { SubscriptionFlights value = null; using (SqlConnection db = new SqlConnection()) { value = db.SubscriptionFlights.FirstOrDefault(t => t.Id == id); } Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsRepo.SelectItem", "Flight was successfully selected"); return(value); } catch (Exception e) { Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace); return(null); } }
public bool Set(SubscriptionFlights item) { return(Update(item)); }
public int Add(SubscriptionFlights item) { return(Insert(item)); }
public string Subscribe(string flightId) { try { var userSets = HttpContext.Current.Request.Cookies["user_login"]; var user = _user.SelectItemByEmail(userSets.Value); var userFlights = _subFlights.SelectItemsByUserId(user.Id); var flight = _subFlights.SelectItemByFlightId(flightId); if (flightId != null) { if (userSets.Value != null) { if (userFlights.Count() != 0 || flight.Count() != 0) { foreach (var t in userFlights) { foreach (var k in flight) { if (t.UserId != k.UserId) { var subflight = new SubscriptionFlights() { FlightId = flightId, UserId = user.Id, Created = DateTime.Now }; _subFlights.Add(subflight); Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsHandler.Subscribe", "Successfully subscribing"); return("OK"); } if (k == flight.Last()) { return("Exist"); } } } } var result = new SubscriptionFlights() { FlightId = flightId, UserId = user.Id, Created = DateTime.Now }; _subFlights.Add(result); Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsHandler.Subscribe", "Successfully subscribing"); return("OK"); } return("NoAuth"); } return("Error"); } catch (Exception e) { Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace); return("NoAuth"); } }