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