public BSEntityFramework_ResultType InsertShopMapDetails(TBL_ShopMapDetails shopsMapDetails) { try { BSEntityFramework_ResultType result; using (BSDBEntities EF = new BSDBEntities()) { using (var transaction = EF.Database.BeginTransaction()) { try { EF.Database.CommandTimeout = 180; if (shopsMapDetails.CreateDate == DateTime.MinValue) { shopsMapDetails.CreateDate = DateTime.Now; EF.TBL_ShopMapDetails.Add(shopsMapDetails); } else { EF.TBL_ShopMapDetails.Attach(shopsMapDetails); EF.Entry(shopsMapDetails).Property(x => x.Latitude).IsModified = true; EF.Entry(shopsMapDetails).Property(x => x.Longitude).IsModified = true; EF.Entry(shopsMapDetails).Property(x => x.UpdateDate).IsModified = true; EF.Entry(shopsMapDetails).Property(x => x.UpdatedBy).IsModified = true; } EF.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); var logact = new LoggerActivity(); result = new BSEntityFramework_ResultType(BSResult.Fail, shopsMapDetails, null, "Technical issue"); logact.SaveLog(logact.ErrorSetup("WebApp", "shops Map Details Failed", "", "", "", ex.Message)); return(result); } } } result = new BSEntityFramework_ResultType(BSResult.Success, shopsMapDetails, null, "Created Sucessfully"); return(result); } catch (DbEntityValidationException dbValidationEx) { return(FormatException(dbValidationEx, shopsMapDetails)); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, shopsMapDetails, null, "Technical issue"); logact.SaveLog(logact.ErrorSetup("WebApp", "shops Map Details Failed", "", "", "", ex.Message)); return(result); } }
public BSEntityFramework_ResultType UpdateProducts(AddProductViewModel Products) { try { using (BSDBEntities EF = new BSDBEntities()) { // EF.TBL_Products.AddOrUpdate(Products.ProductDetails); EF.TBL_Products.Attach(Products.ProductDetails); EF.Entry(Products.ProductDetails).Property(x => x.IsActive).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.AvailableQuantity).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.BarCode).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.IsAvailable).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.MRP).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.OtherJsonDetails).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ProductBrand).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ProductCategoryID).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ProductName).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ProductSubTypeID).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ProductTypeID).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ShopPrice).IsModified = true; EF.Entry(Products.ProductDetails).Property(x => x.ShopID).IsModified = false; if (Products.ProductImages != null && Products.ProductImages.Count > 0 && Products.ProductImages[0] != null) { EF.TBL_ProductImages.Attach(Products.ProductImages[0]); EF.Entry(Products.ProductImages[0]).Property(x => x.ProductImage).IsModified = true; } EF.SaveChanges(); var result = new BSEntityFramework_ResultType(BSResult.Success, Products, null, "Updated Successfully"); return(result); } } catch (DbEntityValidationException dbValidationEx) { return(FormatException(dbValidationEx, Products)); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, Products, null, "Technical issue"); logact.ErrorSetup("WebApp", "UpdateProducts Failed", "", "", "", ex.Message); return(result); } }