public ResultAndError <ZoneProvider> Add(ZoneProvider c) { ResultAndError <ZoneProvider> result = new ResultAndError <ZoneProvider>(); try { db.ZoneProviders.Add(c); db.SaveChanges(); return(result.AddResult(c)); } catch (Exception e) { return(result.AddError(e, HttpStatusCode.InternalServerError)); } }
public bool DeleteMulti(IEnumerable <string> ZoneProviders) { List <ZoneProvider> oZoneProviders = new List <ZoneProvider>(); foreach (string ZoneProviderNo in ZoneProviders) { ZoneProvider oZoneProvider = Get(ZoneProviderNo); if (oZoneProvider != null) { oZoneProviders.Add(oZoneProvider); } } db.ZoneProviders.RemoveRange(oZoneProviders); db.SaveChanges(); return(true); }
public bool UpdateMulti(IEnumerable <ZoneProvider> oZoneProviders, bool insertIfNoExists = false) { foreach (ZoneProvider ZoneProvider in oZoneProviders) { ZoneProvider old = Get(ZoneProvider.Code); if (old == null && insertIfNoExists) { Add(ZoneProvider); } else { db.Entry(old).CurrentValues.SetValues(ZoneProvider); } } db.SaveChanges(); return(true); }
public ResultAndError <ZoneProvider> Update(ZoneProvider c, bool insertIfNoExists = false) { ResultAndError <ZoneProvider> result = new ResultAndError <ZoneProvider>(); try { ZoneProvider old = Get(c.Code); if (old == null && insertIfNoExists) { return(Add(c)); } db.Entry(old).CurrentValues.SetValues(c); db.SaveChanges(); return(result.AddResult(c)); } catch (Exception e) { return(result.AddError(e, HttpStatusCode.InternalServerError)); } }
public ResultAndError <bool> Delete(string id) { ResultAndError <bool> result = new ResultAndError <bool>(); try { ZoneProvider ZoneProvider = Get(id); if (ZoneProvider == null) { return(result.AddError("No se encontro la zona del proveedor con el id " + id)); } db.ZoneProviders.Remove(ZoneProvider); db.SaveChanges(); return(result.AddResult(true)); } catch (Exception e) { return(result.AddError(e, HttpStatusCode.InternalServerError)); } }
public IActionResult UpdZoneProvider([FromBody] ZoneProvider zoneProvider, bool insertIfNoExists = false) { return(Ok(cBS.Update(zoneProvider, insertIfNoExists))); }