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 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()));
}
}
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 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 getGmhByGmhCode(GMH gmhCode)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
System.Diagnostics.Debug.WriteLine(gmhCode);
return(BL.Converters.GMHConverter.convertToDTO(db.GMH.First(s => s.GmhCode == gmhCode.GmhCode)));
}
}
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 User getUser(GMH gMH)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (gMH != null)
{
return(BL.Converters.UserConverter.convertToDTO(db.USERS.FirstOrDefault(u => u.UserCode == gMH.UserCode)));
}
return(new User());
}
}
}//פונקציה שבודקת האם המשתמש קיים במערכת
public static User GetUser(GMH gMH)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
if (gMH != null)
{
return(BL.Converters.UserConverter.convertToDTO(db.USERS.FirstOrDefault(u => u.UserCode == gMH.UserCode)));
}
return(new User());
}
}//פונקציה שממקבלת גמ"ח ומחזירה את המנהל שלה
public static OPINION[] getOpinionsForGMH(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
List <OPINION> p = new List <OPINION>();
//foreach (var op in db.OPINIONS)
//{
// if (op.LandingCode == gmh.)
// p.Add(BL.Converters.OpinionConverter.convertToDTO(op));
//}
return(p.ToArray());
//return BL.Converters.ProductToGmhConverter.convertToDTOarray(db.PRODUCTtoGMH.Where(p=>p.GmhCode==gmh.GmhCode).ToArray());
}
}
public static ProductToGMH[] getProductsForGMH(GMH gmh)
{
using (DAL.Charity_DBEntities db = new DAL.Charity_DBEntities())
{
List <ProductToGMH> p = new List <ProductToGMH>();
foreach (var prtg in db.PRODUCTtoGMH)
{
if (prtg.GmhCode == gmh.GmhCode)
{
p.Add(BL.Converters.ProductToGmhConverter.convertToDTO(prtg));
}
}
return(p.ToArray());
//return BL.Converters.ProductToGmhConverter.convertToDTOarray(db.PRODUCTtoGMH.Where(p=>p.GmhCode==gmh.GmhCode).ToArray());
}
}
public static List <GMH> checkDistance(List <GMH> gmhim, double currl1, double currl2, string location, GMH gmh, int distance)
{
if (currl1 != 0)
{
if (BL.GoogleMaps.GetDistance(gmh.Adress, Convert.ToString(currl1 + " " + currl2)) < distance)
{
gmhim.Add(gmh);
}
}
else if (BL.GoogleMaps.GetDistance(gmh.Adress, location) < distance)
{
gmhim.Add(gmh);
}
else
{
gmhim.Add(gmh);
}
return(gmhim);
}
