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