public static int Create(AirportDataModel data, RequestProfile requestProfile) { var sql = Save(data, "Create", requestProfile); var newId = DBDML.RunScalarSQL("Airport.Insert", sql, DataStoreKey); return(Convert.ToInt32(newId)); }
public void Delete(string value) { var dataQuery = new AirportDataModel(); dataQuery.AirportId = int.Parse(value); AirportDataManager.Delete(dataQuery, SessionVariables.RequestProfile); }
public static string Save(AirportDataModel data, string action, RequestProfile requestProfile) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.AirportInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.AirportUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, AirportDataModel.DataColumns.AirportId); sql = sql + ", " + ToSQLParameter(data, AirportDataModel.DataColumns.CountryId); sql = sql + ", " + ToSQLParameter(data, AirportDataModel.DataColumns.Name); sql = sql + ", " + ToSQLParameter(data, AirportDataModel.DataColumns.Description); sql = sql + ", " + ToSQLParameter(data, AirportDataModel.DataColumns.SortOrder); return(sql); }
public List <Common.Station> GetCurrentStationsState() { List <Common.Station> stations = new List <Common.Station>(); using (AirportDataModel context = new AirportDataModel()) { var DALStations = context.Stations.ToList(); foreach (var station in DALStations) { if (!station.IsAvailable && station.PlaneId != null && station.Plane != null && station.Plane.Name != "") { stations.Add(new Common.Station(station.Number, station.stepKey) { Plane = new Common.Plane(station.Plane.Name, station.Plane.ActionDate, station.Plane.waitingTime, station.Plane.flightState) }); } else { stations.Add(new Common.Station(station.Number, station.stepKey)); } } } return(stations); }
public AirportDataModel GetById(string value) { var dataQuery = new AirportDataModel(); dataQuery.AirportId = int.Parse(value); var result = AirportDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, 1); return(result[0]); }
public static bool DoesExist(AirportDataModel data, RequestProfile requestProfile) { var doesExistRequest = new AirportDataModel(); doesExistRequest.ApplicationId = data.ApplicationId; doesExistRequest.CountryId = data.CountryId; doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
/// <summary> /// A plane is moving /// </summary> /// <param name="Plane">The plane that moves</param> public void MoveRequest(Common.Plane Plane) { using (AirportDataModel context = new AirportDataModel()) { Station previous = null; //If it's not his first station if (Plane.PreviousStationNumber != 0) { previous = context.Stations.Where(s => s.Number == Plane.PreviousStationNumber).FirstOrDefault(); if (previous != null) { previous.PlaneId = null; previous.Plane = null; context.Histories.Add(new History() { StationNumber = previous.Number, DateOut = DateTime.Now, DateIn = null, PlaneId = Plane.Name }); } } var next = context.Stations.Where(s => s.Number == Plane.StationNumber).FirstOrDefault(); if (next != null) { DAL.Plane DalPlane = context.Planes.Where(p => p.Name == Plane.Name).FirstOrDefault(); if (DalPlane == null) { DalPlane = new Plane() { Name = Plane.Name, ActionDate = Plane.ActionDate, flightState = Plane.flightState, PreviousStationNumber = Plane.PreviousStationNumber, StationNumber = Plane.StationNumber, waitingTime = Plane.waitingTime }; context.Planes.Add(DalPlane); } DalPlane.PreviousStationNumber = Plane.StationNumber; DalPlane.StationNumber = Plane.StationNumber; next.PlaneId = DalPlane.Id; next.Plane = DalPlane; context.Histories.Add(new History() { StationNumber = next.Number, DateIn = DateTime.Now, DateOut = null, PlaneId = Plane.Name }); } context.SaveChanges(); } }
public static void Delete(AirportDataModel data, RequestProfile requestProfile) { const string sql = @"dbo.AirportDelete "; var parameters = new { AuditId = requestProfile.AuditId , AirportId = data.AirportId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public List <Common.Relation> GetRelations() { List <Common.Relation> relations = new List <Common.Relation>(); using (AirportDataModel context = new AirportDataModel()) { var DALRelations = context.Relations.ToList(); foreach (var relation in DALRelations) { relations.Add(new Common.Relation(relation.StationId, relation.NextStepId, relation.State)); } } return(relations); }
public List <Common.Plane> GetFutureDeparturesAndArrivals() { List <Common.Plane> FutureDeparturesAndArrivals = new List <Common.Plane>(); using (AirportDataModel context = new AirportDataModel()) { var DalFutureDepartures = context.Departures.Where(a => a.DatePlanned > DateTime.Now).OrderBy(a => a.DatePlanned).ToList(); foreach (var futureDeparture in DalFutureDepartures) { FutureDeparturesAndArrivals.Add(new Common.Plane(futureDeparture.PlaneId, futureDeparture.DatePlanned, futureDeparture.waitingTime, Common.Enums.FlightState.Departure)); } var DalFutureArrivals = context.Arrivals.Where(a => a.DatePlanned > DateTime.Now).OrderBy(a => a.DatePlanned).ToList(); foreach (var futureArrival in DalFutureArrivals) { FutureDeparturesAndArrivals.Add(new Common.Plane(futureArrival.PlaneId, futureArrival.DatePlanned, futureArrival.waitingTime, Common.Enums.FlightState.Arrival)); } } return(FutureDeparturesAndArrivals); }
/// <summary> /// New future departure or arrival to add /// </summary> /// <param name="plane">The new plane</param> public void DepartureOrArrival(Common.Plane plane) { using (AirportDataModel context = new AirportDataModel()) { if (plane.flightState == Common.Enums.FlightState.Departure) { context.Departures.Add(new Departure() { PlaneId = plane.Name, DatePlanned = plane.ActionDate, waitingTime = plane.waitingTime }); } else { context.Arrivals.Add(new Arrival() { PlaneId = plane.Name, DatePlanned = plane.ActionDate, waitingTime = plane.waitingTime }); } context.SaveChanges(); } }
public static List <AirportDataModel> GetEntityDetails(AirportDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.AirportSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , AirportId = dataQuery.AirportId , CountryId = dataQuery.CountryId , Name = dataQuery.Name }; List <AirportDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <AirportDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static string ToSQLParameter(AirportDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case AirportDataModel.DataColumns.AirportId: if (data.AirportId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AirportDataModel.DataColumns.AirportId, data.AirportId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.AirportId); } break; case AirportDataModel.DataColumns.CountryId: if (data.CountryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AirportDataModel.DataColumns.CountryId, data.CountryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.CountryId); } break; case AirportDataModel.DataColumns.Country: if (!string.IsNullOrEmpty(data.Country)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AirportDataModel.DataColumns.Country, data.Country); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.Country); } break; case AirportDataModel.DataColumns.Name: if (!string.IsNullOrEmpty(data.Name)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AirportDataModel.DataColumns.Name, data.Name); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.Name); } break; case AirportDataModel.DataColumns.Description: if (!string.IsNullOrEmpty(data.Description)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, AirportDataModel.DataColumns.Description, data.Description); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.Description); } break; case AirportDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, AirportDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, AirportDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static void Update(AirportDataModel data, RequestProfile requestProfile) { var sql = Save(data, "Update", requestProfile); DBDML.RunSQL("Airport.Update", sql, DataStoreKey); }
public static DataTable Search(AirportDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); return(list.ToDataTable()); }
public void Update([FromBody] AirportDataModel data) { AirportDataManager.Update(data, SessionVariables.RequestProfile); }