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