public static bool addSearch(searches s)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.Searches.Add(Converters.SearchesConverter.convertToDal(s));
try
{
db.SaveChanges();
int count = 0;
foreach (var s1 in db.Searches)
{
if (s.Category == s1.Category && BL.GoogleMaps.GetDistance(s.Adress, s1.Adress) < 50 && s.fingerPrint != s1.fingerPrint)
{
count++;
}
}
{
if (count >= 5)
{
NeedsGmhim ng = new NeedsGmhim
{
Adress = s.Adress,
category = s.Category
};
System.Diagnostics.Debug.WriteLine(s.Adress);
db.NeedsGmhim.Add(BL.Converters.GMHConverter.convertToDal(ng));
try
{
db.SaveChanges();
return(true);
}
catch { return(false); }
}
}
return(false);
}
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 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 bool addReqest(RequestForLoan request)
{
System.Diagnostics.Debug.WriteLine(request.comment);
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.RequestForLoan.Add(Converters.RequestForLoanConverter.convertToDal(request));
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 SetLending(LENDING l)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.LENDINGS.FirstOrDefault(l1 => l1.LendingCode == l.LendingCode).Comment = l.Comment;
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 AddUser(User user)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.USERS.Add(Converters.UserConverter.convertToDal(user));
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 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 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 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);
}
}
}
public static bool addGMH(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.GMH.Add(Converters.GMHConverter.convertToDal(gmh));
try
{
db.SaveChanges();
NeedsGmhim ng = new NeedsGmhim();
ng.category = gmh.CategoryCode;
ng.Adress = gmh.Adress;
needsGmhim.remove(ng);
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 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);
}
}
}
//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 AddGMH(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.GMH.Add(Converters.GMHConverter.convertToDal(gmh));
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 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 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 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 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 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 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 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 bool delete(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
//List<ProductToGMH> pr =BL.Converters.ProductToGmhConverter.convertToDTOList(db.PRODUCTtoGMHs.Where(p => p.GmhCode == gmh.GmhCode).ToList());
//pr.ForEach(p => db.Products.Remove(db.Products.FirstOrDefault(p1=>p1.ProductCode== p.ProductCode)));
db.PRODUCTtoGMH.RemoveRange(db.PRODUCTtoGMH.Where(p => p.GmhCode == gmh.GmhCode));
List <DAL.LENDINGS> list = new List <DAL.LENDINGS>();
List <DAL.Images> list1 = new List <DAL.Images>();
foreach (var l in db.LENDINGS)
{
foreach (var p in db.PRODUCTtoGMH)
{
if (l.ProductCode == p.ProductCodeToGMH && p.GmhCode == gmh.GmhCode)
{
list.Add(l);
}
}
}
foreach (var i in db.Images)
{
foreach (var p in db.PRODUCTtoGMH)
{
if (i.ProductCodeToGMH == p.ProductCodeToGMH && p.GmhCode == gmh.GmhCode)
{
list1.Add(i);
}
}
}
db.LENDINGS.RemoveRange(list);
db.Images.RemoveRange(list1);
db.GMH.Remove((db.GMH.SingleOrDefault(g => g.GmhCode == gmh.GmhCode)));
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 void add(NeedsGmhim ng)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (ng.category != null && ng.category != 0)
{
db.NeedsGmhim.Add(BL.Converters.GMHConverter.convertToDal(ng));
}
db.SaveChanges();
}
}
public static void remove(NeedsGmhim ng)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
foreach (var item in db.NeedsGmhim)
{
if (item.CATEGORY == ng.category && BL.GoogleMaps.GetDistance(ng.Adress, item.ADRESS) < 20)
{
db.NeedsGmhim.Remove(item);
db.SaveChanges();
}
}
}
}
public static bool saveChangesInGmhim(User u)
{
List <GMH> myGmhim = new List <GMH>();
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
foreach (DAL.GMH g in db.GMH.Where(g => g.UserCode == u.UserCode).ToList())
{
g.e_mail = u.E_mail;
g.Phone = u.Phone;
g.Adress = u.Adress;
}
try { db.SaveChanges(); return(true); }
catch { return(false); }
}
}
public static bool saveChanges(Donations d)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.Donations.FirstOrDefault(d1 => d1.donationCode == d.donationCode).donationName = d.donationName;
db.Donations.FirstOrDefault(d1 => d1.donationCode == d.donationCode).Description = d.Description;
db.Donations.FirstOrDefault(d1 => d1.donationCode == d.donationCode).Picture = d.Picture;
try
{
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public static bool edit(ProductToGMH pTgmh, List <string> photos)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).FreeDescription = pTgmh.FreeDescription;
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).IsDisposable = pTgmh.IsDisposable;
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).Status = pTgmh.Status;
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).SecurityDepositAmount = pTgmh.SecurityDepositAmount;
db.PRODUCTtoGMH.FirstOrDefault(p => p.ProductCodeToGMH == pTgmh.ProductCodeToGMH).ProductCode = pTgmh.ProductCode;
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 int AddDonations(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();
foreach (var item in db.RequestForLoan)
{
///if( תרומה מתאימה לITEM)
BL.EmailService.offerDonationMail("תרומה תואמת לבקשתך", d.donationCode, db.USERS.Find(item.UserCode).E_mail);
}
int code = db.Donations.ToArray().Last().donationCode;//
//BL.EmailService.SendMail("תרומתך התקבלה", code+"מספר התרומה",d.donorEmail);
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 int AddDonations(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();
//foreach (var item in db.RequestForLoan)
//{
// ///if( תרומה מתאימה לITEM)
// BL.EmailService.offerDonationMail("תרומה תואמת לבקשתך", d.donationCode, db.USERS.Find(item.UserCode).E_mail);
//}
//int code = db.Donations.ToArray().Last().donationCode;//
//BL.EmailService.SendMail("תרומתך התקבלה", code+"מספר התרומה",d.donorEmail);
int code = db.Donations.ToArray().Last().donationCode;
// BL.EmailService.SendMail("תרומתך התקבלה", code+"מספר התרומה",d.donorEmail);
List <DAL.GMH> gMHs = new List <DAL.GMH>();
List <DAL.RequestForLoan> requests = new List <DAL.RequestForLoan>();
requests = db.RequestForLoan.Where(r => r.ProductCode == d.ProductCode).ToList();
gMHs = db.GMH.Where(g => g.CategoryCode == d.Category).ToList();
if (requests.Count() == 0)//אם אין גמח מאותה קטגוריה
{
db.Donations.Add(Converters.DonationConverter.convertToDAL(d));
}
else if (requests.Count() == 1)//אם יש רק אחד באותה קטגוריה
{
BL.EmailService.SendMail("קבלת הצעה לתרומה", code + "מספר התרומה", db.GMH.FirstOrDefault(g => g.CategoryCode == d.Category).e_mail);
}
else if (requests.Count() > 1)//אם יש יותר בודקים מרחק
{
foreach (DAL.GMH g in db.GMH)
{
if (BL.GoogleMaps.GetDistance(g.Adress, d.Adress) < 30)
{
gMHs.Add(g);
}
}
if (gMHs.Count() == 0)
{
} //מה לעשות אם אין אף אחד בקרבה
else if (gMHs.Count() == 1) //אם יש אחד בקרבה גדולה
{
BL.EmailService.SendMail("קבלת הצעה לתרומה", code + "מספר התרומה", gMHs[0].e_mail);
}
else if (gMHs.Count() > 1)
{
gMHs = gMHs.Where(g => g.UserCode == (requests.OrderBy(g1 => g1.RequestDate).FirstOrDefault().UserCode)).ToList();
if (gMHs.Count() == 1)
{
BL.EmailService.SendMail("קבלת הצעה לתרומה", code + "מספר התרומה", gMHs[0].e_mail);
}
//else if (gMHs.Count() > 1)
//{
// //gMHs = gMHs.Where(g => g.UserCode == (db.OPINIONS.OrderBy(o=>o.Rating).FirstOrDefault().LandingCode)).ToList();
//}
}
}
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);
}
}
}
