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