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 InsertShopInPostal(TBL_ShopsInPostalCodes shopsInPostal, int shopID) { try { BSEntityFramework_ResultType result; using (BSDBEntities EF = new BSDBEntities()) { using (var transaction = EF.Database.BeginTransaction()) { try { EF.Database.CommandTimeout = 180; shopsInPostal.ShopID = shopID; EF.TBL_ShopsInPostalCodes.Add(shopsInPostal); EF.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); var logact = new LoggerActivity(); result = new BSEntityFramework_ResultType(BSResult.Fail, shopsInPostal, null, "Technical issue"); logact.SaveLog(logact.ErrorSetup("WebApp", "InsertShopPostalDetails Failed", "", "", "", ex.Message)); return(result); } } } result = new BSEntityFramework_ResultType(BSResult.Success, shopsInPostal, null, "Created Sucessfully"); return(result); } catch (DbEntityValidationException dbValidationEx) { return(FormatException(dbValidationEx, shopsInPostal)); } catch (Exception ex) { var logact = new LoggerActivity(); var result = new BSEntityFramework_ResultType(BSResult.Fail, shopsInPostal, null, "Technical issue"); logact.SaveLog(logact.ErrorSetup("WebApp", "InsertShopPostalDetails Failed", "", "", "", ex.Message)); return(result); } }