Example #1
0
        //Metodo que agrega una App a la base de datos
        public static bool AddApp(string _Dev, string _Name, string _Description, string _Category, Byte[] _Photo)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                var Existent = (from c in dbContext.APPs
                                where c.Name == _Name
                                select c).Any();
                if (Existent == true)
                {
                    return false;
                    //throw new InvalidOperationException("Ya existe un App con ese nombre. Escoge otro");
                }
                else
                {
                    int IdDeveloper = (from c in dbContext.DEVELOPERs
                                       where c.Email == _Dev
                                       select c.ID_Developer).First();

                    var app = new APP
                    {
                        ID_Developer = IdDeveloper,
                        Name = _Name,
                        PublishedDate = DateTime.Now,
                        Description = _Description,
                        Category = _Category,
                        Photo = _Photo,
                        MembershipQueue = false
                    };
                    dbContext.APPs.Add(app);
                    var changesSaved = dbContext.SaveChanges();
                    return changesSaved >= 1;
                }
            }
        }
Example #2
0
        public static bool AddApp_Purchased(int  IdApp, string Correo)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                var IdCustomer = (from c in dbContext.CUSTOMERs
                                  where c.Email == Correo
                                  select c.ID_Customer).Single();

                var app_purchased = new APP_PURCHASED
                {
                    ID_App = IdApp,
                    ID_Customer = IdCustomer
                };
                dbContext.APP_PURCHASED.Add(app_purchased);
                var changesSaved = dbContext.SaveChanges();
                return changesSaved >= 1;
            }
        }
Example #3
0
 public static bool updateDeveloper(string _firstName, string _lastName, string _email, string _password)
 {
     using (var dbContext = new LAUNCHEntities())
     {
         var buscarCustomer = from c in dbContext.DEVELOPERs
                              where c.Email == _email
                              select c;
         foreach (var c in buscarCustomer)
         {
             c.FirstName = _firstName;
             c.LastName = _lastName;
             c.Email = _email;
             c.Password = _password;
         }
         var changesSaved = dbContext.SaveChanges();
         return changesSaved >= 1;
     }
 }
Example #4
0
        //Solo funciona en customers
        public static bool[] Login(string _email, string _password)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                bool[] Resultados = new bool[2];
                var EncontrarCliente = (from e in dbContext.CUSTOMERs
                                        where e.Email == _email && e.Password == _password
                                        select e).Any();

                var EncontrarDeveloper = (from e in dbContext.DEVELOPERs
                                          where e.Email == _email && e.Password == _password
                                          select e).Any();

                Resultados[0] = EncontrarCliente || EncontrarDeveloper;
                if (Resultados[0])
                    Resultados[1] = EncontrarDeveloper;
                return Resultados;
            }
        }
Example #5
0
        public static List<List<string>> getSuscriptionApps()
        {
            using (var dbContext = new LAUNCHEntities())
            {
                List<List<string>> thePublished = new List<List<string>>();
                var getPurchases = from p in dbContext.APPs
                                   orderby p.PublishedDate ascending
                                   select p;
                int i = 0;
                foreach (var p in getPurchases)
                {
                    if (i < 10)
                    {
                        i++;
                        List<string> temp = new List<string>();
                        temp.Add(p.ID_App.ToString());
                        temp.Add(p.Name);
                        temp.Add(String.Format("{0}/{1}/{2}", p.PublishedDate.Day, p.PublishedDate.Month, p.PublishedDate.Year));
                        temp.Add(p.Category);
                        temp.Add(p.Description);

                        thePublished.Add(temp);
                    }
                    else break;
                }
                return thePublished;
            }
        }
Example #6
0
        //Da la informacion de la App solicitada
        public static List<string> getInfofromApp(int _IdApp)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                var App = dbContext.APPs.First(a => a.ID_App == _IdApp);
                var Developer = dbContext.DEVELOPERs.First(a => a.ID_Developer == App.ID_Developer);
                List<string> temp = new List<string>();
                temp.Add(Developer.FirstName + " " + Developer.LastName);
                temp.Add(App.Name);
                temp.Add(String.Format("{0}/{1}/{2}", App.PublishedDate.Day, App.PublishedDate.Month, App.PublishedDate.Year));
                temp.Add(App.Category);
                temp.Add(App.Description);

                return temp;
            }
        }
Example #7
0
        //Lee todas las aplicaciones compradas por un usuario
        public static List<List<string>> getAppsPurchasedByCustomer(string Email)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                List<List<string>> thePurchases = new List<List<string>>();
                var Customer = dbContext.CUSTOMERs.First(c => c.Email == Email);
                var getPurchases = from p in dbContext.APP_PURCHASED
                                   where p.ID_Customer == Customer.ID_Customer
                                   select p;

                int i = 0;
                foreach (var p in getPurchases)
                {
                    if (i < 10)
                    {
                        i++;
                        List<string> temp = new List<string>();
                        temp.Add(p.ID_App.ToString());
                        temp.Add(p.APP.Name);
                        temp.Add(String.Format("{0}/{1}/{2}", p.APP.PublishedDate.Day, p.APP.PublishedDate.Month, p.APP.PublishedDate.Year));
                        temp.Add(p.APP.Category);
                        temp.Add(p.APP.Description);

                        thePurchases.Add(temp);
                    }
                    else break;
                }
                return thePurchases;
            }
        }
Example #8
0
        public static List<List<string>> getAppsPublishedByDeveloper(string DeveloperEmail)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                List<List<string>> thePublished = new List<List<string>>();

                DEVELOPER Dev = (from d in dbContext.DEVELOPERs
                                 where d.Email == DeveloperEmail
                                 select d).Single();

                var getPurchases = from p in dbContext.APPs
                                   where p.ID_Developer == Dev.ID_Developer
                                   orderby p.PublishedDate ascending
                                   select p;
                int i = 0;
                foreach (var p in getPurchases)
                {
                    if (i < 10)
                    {
                        i++;
                        List<string> temp = new List<string>();
                        temp.Add(p.ID_App.ToString());
                        temp.Add(p.Name);
                        temp.Add(String.Format("{0}/{1}/{2}", p.PublishedDate.Day, p.PublishedDate.Month, p.PublishedDate.Year));
                        temp.Add(p.Category);
                        temp.Add(p.Description);

                        thePublished.Add(temp);
                    }
                    else break;
                }
                return thePublished;
            }
        }
Example #9
0
        //Lee todos los comments disponibles de una aplicacion
        public static List<COMMENT> getAllCommentsFromApp(APP app)
        {
            using (var dbContext = new LAUNCHEntities())
            {
                List<COMMENT> theComments = new List<COMMENT>();
                var getComments = from c in dbContext.COMMENTs
                                  where c.ID_App == app.ID_App
                                  select c;

                foreach (var c in getComments)
                {
                    theComments.Add(c);
                }
                return theComments;

            }
        }
Example #10
0
        //Lee todas las aplicaciones disponibles en la base de datos
        public static List<APP> getAllApps()
        {
            using (var dbContext = new LAUNCHEntities())
            {
                List<APP> theApps = new List<APP>();
                var getApps = from a in dbContext.APPs
                              select a;

                foreach (var g in getApps)
                {
                    theApps.Add(g);
                }
                return theApps;
            }
        }
Example #11
0
 //Manda llamar de la base de datos el Developer con el email que se le mande
 public static DEVELOPER getActiveDeveloper(string _email)
 {
     using (var dbContext = new LAUNCHEntities())
     {
         return dbContext.DEVELOPERs.First(d => d.Email == _email);
     }
 }
Example #12
0
 //Manda llamar de la base de datos el Customer con el email que se le mande
 public static CUSTOMER getActiveCustomer(string _email)
 {
     using (var dbContext = new LAUNCHEntities())
     {
         return dbContext.CUSTOMERs.First(u => u.Email == _email);
     }
 }
Example #13
0
 public static bool AddMembership()
 {
     using (var dbContext = new LAUNCHEntities())
     {
         var membership = new MEMBERSHIP
         {
             LastPayment = DateTime.Now,
             Active = true
         };
         dbContext.MEMBERSHIPs.Add(membership);
         var changesSaved = dbContext.SaveChanges();
         return changesSaved >= 1;
     }
 }
Example #14
0
 //Metodo que agrega un Developer a la base de datos
 public static bool AddDeveloper(string _FirstName, string _LastName, string _Email, string _Password)
 {
     using (var dbContext = new LAUNCHEntities())
     {
         var Existent = (from c in dbContext.DEVELOPERs
                         where c.Email == _Email
                         select c).Any();
         //tira una excepcion si ya existe, y si no, agrega al developer a la base y lo guarda
         if (Existent == true)
         {
             throw new InvalidOperationException("Ya existe un developer con ese correo. Escoge otro");
         }
         else
         {
             try
             {
                 var developer = new DEVELOPER
                 {
                     FirstName = _FirstName,
                     LastName = _LastName,
                     Email = _Email,
                     Password = _Password
                 };
                 dbContext.DEVELOPERs.Add(developer);
                 var changesSaved = dbContext.SaveChanges();
                 return changesSaved >= 1;
             }
             catch (Exception ex)
             {
                 string error = ex.Message;
                 return false;
             }
         }
     }
 }
Example #15
0
        public static byte[] getAppsPhoto(string NameApp)
        {
            using (var dbContext = new LAUNCHEntities())
            {

                var getPhoto = (from p in dbContext.APPs
                                   where p.Name == NameApp
                                   select p.Photo).Single();

                return getPhoto;
            }
        }
Example #16
0
 //Metodo que agrega comments a una aplicacion
 public static bool AddComment(CUSTOMER customer, APP app, string _content)
 {
     using (var dbContext = new LAUNCHEntities())
     {
         var comment = new COMMENT
         {
             ID_Customer = customer.ID_Customer,
             ID_App = app.ID_App,
             Date = DateTime.Now,
             Content = _content
         };
         dbContext.COMMENTs.Add(comment);
         var changesSaved = dbContext.SaveChanges();
         return changesSaved >= 1;
     }
 }
Example #17
0
        //Metodo que agrega un Customer a la base de datos
        public static bool AddCustomer(string _FirstName, string _LastName, string _Email, string _Password)
        {
            try
            {
                using (var dbContext = new LAUNCHEntities())
                {
                    dbContext.Database.Connection.Open();
                    //verifica si ya existe un customer en la base de datos con ese email
                    var Existent = (from c in dbContext.CUSTOMERs
                                    where c.Email == _Email
                                    select c).Any();
                    //tira una excepcion si ya existe, y si no, agrega al customer a la base y lo guarda
                    if (Existent == true)
                    {
                        throw new InvalidOperationException("Ya existe un usuario con ese correo. Escoge otro");
                    }

                    var customer = new CUSTOMER
                    {
                        FirstName = _FirstName,
                        LastName = _LastName,
                        Email = _Email,
                        Password = _Password
                    };
                    dbContext.CUSTOMERs.Add(customer);
                    var changesSaved = dbContext.SaveChanges();
                    return changesSaved >= 1;

                }
            }
            catch (Exception ex)
            {
                string error = ex.Message;
                return false;
            }
        }