Ejemplo n.º 1
0
 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);
     }
 }
Ejemplo n.º 2
0
        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);
        }