private bool updateLocality(TELCP_LOCPTD obj) { try { using (var db = new ticketpremiumEntities()) { var locality = db.TELCP_LOCPTD.Find(obj.TELCP_CODIGO, obj.TEPAF_CODIGO); locality.TELCP_DISPON = obj.TELCP_DISPON; db.Entry(locality).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
private SoccerGame updateLocalitiesSoccerGame(SoccerGame client_soccergame) { SoccerGame result_soccergame = getSoccerGame(client_soccergame.code_soccergame); if (result_soccergame == null) { return(null); } List <Locality> list_location = new List <Locality>(); try { foreach (Locality aux in client_soccergame.localities) { TELCP_LOCPTD telcpLocptd = null; using (ticketpremiumEntities db = new ticketpremiumEntities()) { telcpLocptd = db.TELCP_LOCPTD.Find(aux.code_locality, aux.code_soccergame); } if (telcpLocptd != null && ((telcpLocptd.TELCP_CANBAS - telcpLocptd.TELCP_DISPON) >= aux.availability) && aux.availability > 0) { TELCP_LOCPTD locality = telcpLocptd; locality.TELCP_DISPON = locality.TELCP_DISPON + aux.availability; if (updateLocality(locality)) { list_location.Add(new Locality() { code_locality = locality.TELCP_CODIGO, code_soccergame = locality.TEPAF_CODIGO, availability = aux.availability, price = (float)(aux.availability * locality.TELCP_PRECIO) }); } } } result_soccergame.localities = list_location; }catch (Exception e) { result_soccergame = null; } return(result_soccergame); }