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