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