public static List <DTO.CategoryGMH> GetCategories()
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.CategoryGMHConvereter.ConvertToDTOList((db.CategoryGMH.Select(c => c).ToList())));
}
}
public static List <Donations> GetDonations()
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.DonationConverter.convertToDTOList(db.Donations.ToList()));
}
}
public static bool deleteLending(LENDING l)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
DAL.LENDINGS l1 = db.LENDINGS.SingleOrDefault(le => le.ProductCode == l.ProductCode && le.LendingDate == l.LendingDate);
db.LENDINGS.Remove(l1);
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
}//פונקציה שמקבלת קוד תרומה ומחזירה את אותה תרומה
public static bool RemoveDonation(Donations d)//פונקציה שמקבלת תרומה ומוחקת אותה מטבלת בתרומות
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (d != null)
{
db.DonationOffers.RemoveRange(db.DonationOffers.Where(d1 => d.donationCode == d1.DonationCode).ToList());
db.Donations.Remove(db.Donations.FirstOrDefault(d1 => d.donationCode == d1.donationCode));
}
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static bool RemoveDonation(Donations d)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.Donations.Remove(BL.Converters.DonationConverter.convertToDAL(d));
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static bool addComplaint(Complaint complaint)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.Complaint.Add(Converters.ComplaintConverter.convertToDAL(complaint));
try
{
db.SaveChanges();
System.Diagnostics.Debug.WriteLine("yes");
return(true);
}
catch (DbEntityValidationException ex)
{
//הדפסת שגיאה בקישור לדאטא בס
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
//private static Donations donations;
public static int AddDonations(Donations d)
{
//donations = d;
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
// if (d.MasterCategory == 0) d.MasterCategory = null;
//מוסיפים תמיד?
db.Donations.Add(Converters.DonationConverter.convertToDAL(d));
try
{
db.SaveChanges();
int code = db.Donations.ToArray().Last().donationCode;
d.donationCode = code;
BL.EmailService.SendMail("תרומתך התקבלה", code + "מספר התרומה", d.donorEmail);
CoordinationDonation(d);
return(code);
//שליחת מייל
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(0);
}
}
}
public static bool delete(ProductToGMH p)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.LENDINGS.RemoveRange(db.LENDINGS.Where(l => l.ProductCode == p.ProductCodeToGMH));
db.Images.RemoveRange(db.Images.Where(i => i.ProductCodeToGMH == p.ProductCodeToGMH));
DAL.PRODUCTtoGMH p1 = db.PRODUCTtoGMH.SingleOrDefault(pt => pt.ProductCodeToGMH == p.ProductCodeToGMH);
if (p1 != null)//לבינתיים
{
db.PRODUCTtoGMH.Remove(p1);
}
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static List <Images> getImages(ProductToGMH pTgmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.ImagesConverter.convertToDTOList(db.Images.Where(i => i.ProductCodeToGMH == pTgmh.ProductCodeToGMH).ToList()));
}
}
public static bool add(ProductToGMH pTgmh, List <string> photos)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.PRODUCTtoGMH.Add(Converters.ProductToGmhConverter.convertToDal(pTgmh));
photos.ForEach(p =>
{
DAL.Images image = new DAL.Images();
image.Path = p;
image.ProductCodeToGMH = pTgmh.ProductCodeToGMH;
db.Images.Add(image);
});
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex) {
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static PRODUCT[] getProducts()
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.ProductConverter.convertToDTOList((db.Products.Select(p => p).ToList())).ToArray());
}
}
public static List <NeedsGmhim> GetNeedsGmhim()
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.GMHConverter.convertToDTOList(db.NeedsGmhim.ToList()));
}
}
public static int AddCategory(CategoryGMH c)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (c.MasterCategoryCode == 0)
{
c.MasterCategoryCode = null;
}
db.CategoryGMH.Add(BL.Converters.CategoryGMHConvereter.ConvertToDAL(c));
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
}
db.CategoryGMH.ToArray().Last().MasterCategoryCode = null;
return(db.CategoryGMH.ToArray().Last().CategoryCode);
}
}
public static string GetCategoryName(int c)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return((db.CategoryGMH.FirstOrDefault(c1 => c1.CategoryCode == c)).CategoryName);
}
}
public static bool saveChange(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
object a = db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode);
db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode).GmhName = gmh.GmhName;
db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode).Phone = gmh.Phone;
db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode).e_mail = gmh.e_mail;
db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode).comments = gmh.comments;
db.GMH.FirstOrDefault(g => gmh.GmhCode == g.GmhCode).Adress = gmh.Adress;
try
{
db.SaveChanges();
System.Diagnostics.Debug.WriteLine("yes");
return(true);
}
catch (DbEntityValidationException ex)
{
//הדפסת שגיאה בקישור לדאטא בס
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static PRODUCT[] getProductsAccordingToGmhCategory(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.ProductConverter.convertToDTOarray(db.Products.Where(p => p.CategoryCode == gmh.CategoryCode).ToArray()));
}
}
public static GMH[] getAllGmhs()
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.GMHConverter.convertToDTOarray((db.GMH.Select(g => g).ToArray())));
}
}
public static PRODUCT getProduct(ProductToGMH pTgmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.ProductConverter.convertToDTO(db.Products.FirstOrDefault(p => p.ProductCode == pTgmh.ProductCode)));
}
}
public static void donationAnswer(bool b, int userCode, int donationCode)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (b == false)
{
db.DonationOffers.Add(new DAL.DonationOffers {
UserCode = userCode, DonationCode = donationCode
});
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
}
CoordinationDonation(BL.Converters.DonationConverter.convertToDTO(db.Donations.FirstOrDefault(d => d.donationCode == donationCode)));
}
else
{
RemoveDonation(BL.Converters.DonationConverter.convertToDTO(db.Donations.FirstOrDefault(d => d.donationCode == donationCode)));
}
}
}
public static int addProduct(PRODUCT p)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.Products.Add(Converters.ProductConverter.convertToDal(p));
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
}
return(db.Products.ToArray().Last().ProductCode);
}
}
}//פונקציה שמחזירה את כל התרומות
public static Donations GetDonation(int code)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.DonationConverter.convertToDTO(db.Donations.FirstOrDefault(d => d.donationCode == code)));
}
}//פונקציה שמקבלת קוד תרומה ומחזירה את אותה תרומה
public static bool saveChange(ProductToGMH pTgmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).Amount = pTgmh.Amount;
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static Donations GetDonation(int code)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.DonationConverter.convertToDTO(db.Donations.FirstOrDefault(d => d.donationCode == code)));
}
}
public static bool saveChanges(User user)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).Name = user.Name;
// db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).Password = user.Password;
db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).Phone = user.Phone;
db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).E_mail = user.E_mail;
// db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).Cell_Phone = user.Cell_Phone;
db.USERS.FirstOrDefault(u => u.UserCode == user.UserCode).Adress = user.Adress;
try { db.SaveChanges(); return(true); }
catch (DbEntityValidationException ex)
{
//הדפסת שגיאה בקישור לדאטא בס
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static List <Donations> filterDonations(int c, int tc, string adress)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
List <Donations> donations = new List <Donations>();
if (tc != 0)
{
donations.AddRange(BL.Converters.DonationConverter.convertToDTOList(db.Donations.Where(d => d.Category == tc).ToList()));
}
//else if (c != 0)
//{
// donations.AddRange(BL.Converters.DonationConverter.convertToDTOList(db.Donations.Where(d => d.MasterCategory == c).ToList()));
//}
if (adress != "undefined")
{
foreach (DAL.Donations d in db.Donations)
{
if (BL.GoogleMaps.GetDistance(d.Adress, adress) < 50)
{
donations.Add(BL.Converters.DonationConverter.convertToDTO(d));
}
}
}
return(donations);
}
}
public static User getUser(int code)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.UserConverter.convertToDTO(db.USERS.FirstOrDefault(u => u.UserCode == code)));
}
}
public static bool addLending(LENDING l)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.LENDINGS.Add(Converters.LendingConverter.convertToDAL(l));
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine(
"Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
System.Diagnostics.Debug.WriteLine("no");
return(false);
}
}
}
public static GMH[] getMyGmhim(User user)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.GMHConverter.convertToDTOarray((db.GMH.Where(g => g.UserCode == user.UserCode).ToArray())));
}
}
public static List <LENDING> getLendings(ProductToGMH p)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.LendingConverter.convertToDTOList(db.LENDINGS.Where(l => l.ProductCode == p.ProductCodeToGMH).ToList()));
}
}
public static ProductToGMH[] getProductsForGMH(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
return(BL.Converters.ProductToGmhConverter.convertToDTOarray(db.PRODUCTtoGMH.Where(p => p.GmhCode == gmh.GmhCode).ToArray()));
}
}
