//---------------------------------------------------- //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; }