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