public static List <tbl_category_donation> getCategoryDonations()
{
using (var data = new ProyectoCovidDAW2020Entity()) {
data.Configuration.LazyLoadingEnabled = false;
return(data.tbl_category_donation.ToList());
}
}
public static List <tbl_user> getPersonsVulnerable()
{
using (var data = new ProyectoCovidDAW2020Entity()) {
data.Configuration.LazyLoadingEnabled = false;
return(data.tbl_user.Include("tbl_user_attribute").Where(x => x.tbl_role_id == 3).ToList());
}
}
public static bool create(tbl_user user)
{
var data = new ProyectoCovidDAW2020Entity();
data.tbl_user.Add(user);
data.SaveChanges();
return(true);
}
public static tbl_user getByDNI(String dni)
{
var data = new ProyectoCovidDAW2020Entity();
data.Configuration.LazyLoadingEnabled = false;
tbl_user user = data.tbl_user.Where(x => x.DNI == dni).FirstOrDefault();
return(user);
}
public static tbl_user getByDNIandPassword(String dni, String pass)
{
var data = new ProyectoCovidDAW2020Entity();
data.Configuration.LazyLoadingEnabled = true;
tbl_user user = data.tbl_user.Include("tbl_donation").Where(x => x.DNI == dni && x.password == pass).FirstOrDefault();
return(user);
}
public static bool create(tbl_donation donation)
{
using (var data = new ProyectoCovidDAW2020Entity())
{
data.tbl_donation.Add(donation);
data.SaveChanges();
return(true);
}
return(false);
}
public static bool create(tbl_user user, tbl_user_attribute userAttribute)
{
var data = new ProyectoCovidDAW2020Entity();
data.tbl_user.Add(user);
data.SaveChanges();
var lastShowPieceId = data.tbl_user.Max(x => x.id);
userAttribute.tbl_user_id = lastShowPieceId;
data.tbl_user_attribute.Add(userAttribute);
data.SaveChanges();
return(true);
}
public static bool AssignDonation(int idDonation, int idPerson)
{
var data = new ProyectoCovidDAW2020Entity();
tbl_donation donation = data.tbl_donation.Where(x => x.id == idDonation).FirstOrDefault();
if (donation == null)
{
return(false);
}
donation.tbl_user_person = idPerson;
donation.state = 4;
donation.fecha_assign = DateTime.Now;
data.SaveChanges();
return(true);
}
public static bool updateDonationState(int idDonation, int state)
{
using (var data = new ProyectoCovidDAW2020Entity())
{
tbl_donation donation = data.tbl_donation.Where(x => x.id == idDonation).FirstOrDefault();
if (donation == null)
{
return(false);
}
donation.state = state;
if (state == 4)
{
donation.fecha_assign = DateTime.Now;
}
else if (state == 1)
{
donation.fecha_delivery = DateTime.Now;
}
data.SaveChanges();
return(true);
}
}
public static List <tbl_donation> getDonationsForDelivery()
{
var data = new ProyectoCovidDAW2020Entity();
return(data.tbl_donation.Where(x => x.state == 4 || x.state == 1).ToList());
}
public static List <tbl_donation> getAllDonations()
{
var data = new ProyectoCovidDAW2020Entity();
return(data.tbl_donation.ToList());
}
