//----------------------------------------------------
//Create Service
public static void createService(Service service)
{
service.service_activity = "1";
DbConn.CONN.Service.AddObject(service);
foreach (WeightRangeService _wrs in service.WeightRangeService)
{
_wrs.service_id = service.service_id;
_wrs.weightRangeService_activity = "1";
DbConn.CONN.WeightRangeService.AddObject(_wrs);
}
DbConn.CONN.SaveChanges();
}
//--------------------------------------------------
//Service JSON Object
public static Object service(Service service)
{
Object[] wrs = new Object[service.WeightRangeService.Count];
int i = 0;
foreach(WeightRangeService _wrs in service.WeightRangeService)
{
wrs[i] = weightRangeServiceObj(_wrs);
i++;
}
if (i > 0)
{
return new
{
service_id = service.service_id,
service_name = service.service_name,
service_price = service.service_price,
service_desc = service.service_description,
airbase_id = service.airbase_id,
aircraftType_code = service.aircraftType_code,
service_type = service.service_type,
service_weightRangeService = wrs
};
}
else
{
return new
{
service_id = service.service_id,
service_name = service.service_name,
service_price = service.service_price,
service_desc = service.service_description,
airbase_id = service.airbase_id,
aircraftType_code = service.aircraftType_code,
service_type = service.service_type
};
}
}
//----------------------------------------------------
//Update Service
public static void updateService(Service service, Service newValues)
{
DbConn.CONN.Service.Include("WeightRangeService");
service.service_name = newValues.service_name;
service.service_price = newValues.service_price;
service.service_description = newValues.service_description;
service.aircraftType_code = newValues.aircraftType_code;
service.service_type = newValues.service_type;
int i = 0;
while (i < service.WeightRangeService.Count)
{
WeightRangeService current = service.WeightRangeService.ElementAt(i);
if (weightRangeServiceById(newValues, current.weightRangeService_id) == null)
{
service.WeightRangeService.Remove(current);
DbConn.CONN.DeleteObject(current);
}
else
{
i++;
}
}
int j = 0;
while (j < newValues.WeightRangeService.Count)
{
WeightRangeService current = newValues.WeightRangeService.ElementAt(j);
WeightRangeService toUpdate = weightRangeServiceById(service, current.weightRangeService_id);
if (toUpdate == null)
{
current.service_id = service.service_id;
DbConn.CONN.WeightRangeService.AddObject(current);
service.WeightRangeService.Add(current);
}
else
{
toUpdate.service_id = service.service_id;
toUpdate.weightRangeService_priceFixed = current.weightRangeService_priceFixed;
toUpdate.weightRangeService_pricePerTon = current.weightRangeService_pricePerTon;
toUpdate.weightRangeService_activity = current.weightRangeService_activity;
toUpdate.weightRangeService_tonMax = current.weightRangeService_tonMax;
toUpdate.weightRangeService_tonMin = current.weightRangeService_tonMin;
j++;
}
}
DbConn.CONN.SaveChanges();
}
//----------------------------------------------------
//Disable Service
public static void removeService(Service service)
{
service.service_activity = "0";
DbConn.CONN.SaveChanges();
}
public static WeightRangeService weightRangeServiceById(Service s, long id)
{
if (id != 0)
{
foreach (WeightRangeService _wrs in s.WeightRangeService)
{
if (_wrs.weightRangeService_id == id)
{
return _wrs;
}
}
}
return null;
}
internal static bool isValidService(Service service)
{
return service != null
&& service.airbase_id != null && service.airbase_id != 0
&& !string.IsNullOrWhiteSpace(service.service_name)
&& (service.service_type == "forfait" || (service.service_type == "tonnage" && service.service_price == 0));
}
/// <summary>
/// Méthode déconseillée pour ajouter un nouvel objet à l'EntitySet Service. Utilisez la méthode .Add de la propriété ObjectSet<T> associée à la place.
/// </summary>
public void AddToService(Service service)
{
base.AddObject("Service", service);
}
/// <summary>
/// Créez un nouvel objet Service.
/// </summary>
/// <param name="service_id">Valeur initiale de la propriété service_id.</param>
public static Service CreateService(global::System.Int64 service_id)
{
Service service = new Service();
service.service_id = service_id;
return service;
}
