public bool UpdateSite(MstSite site, MstFinYear finYear) { bool tranResult = false; using (var dbContextTransaction = Context.Database.BeginTransaction()) { try { var existSite = GetSiteByID(site.SiteCode); existSite.SiteOfficialName = site.SiteOfficialName; existSite.SiteShortName = site.SiteShortName; existSite.SiteAddressLn1 = site.SiteAddressLn1; existSite.SiteAddressLn2 = site.SiteAddressLn2; existSite.SiteAddressLn3 = site.SiteAddressLn3; existSite.ContactPerson = site.ContactPerson; existSite.CentralSalesTaxNo = site.CentralSalesTaxNo; existSite.EmailId = site.EmailId; existSite.SiteTelephone1 = site.SiteTelephone1; existSite.LocalSalesTaxNo = site.LocalSalesTaxNo; existSite.FaxNo = site.FaxNo; existSite.CountryCode = site.CountryCode; existSite.LocalCurrancyCode = site.LocalCurrancyCode; existSite.UPDATEDON = site.UPDATEDON; existSite.UPDATEDAT = site.UPDATEDAT; existSite.UPDATEDBY = site.UPDATEDBY; Context.Entry(existSite).State = EntityState.Modified; var IsFinyearExist = GetFinYearDetailsBySiteID(site.SiteCode); if (IsFinyearExist == null) { Context.MstFinYear.Add(finYear); } Context.SaveChanges(); dbContextTransaction.Commit(); tranResult = true; } catch (DbEntityValidationException dbEx) { dbContextTransaction.Rollback(); foreach (DbEntityValidationResult entityErr in dbEx.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { Logging.Logger.Log("Error Property Name " + error.PropertyName + " : Error Message: " + error.ErrorMessage, Logging.Logger.LogingLevel.Error); Logging.Logger.Log(dbEx, Logging.Logger.LogingLevel.Error); } } } catch (Exception ex) { dbContextTransaction.Rollback(); Logging.Logger.Log(ex, Logging.Logger.LogingLevel.Error); throw ex; } } return(tranResult); }
public bool SaveSite(MstSite site, MstFinYear finYear, MstAreaCode areaCode, MstCurrency currency, MstSiteCurrancyMap siteCurrency) { bool tranResult = false; using (var dbContextTransaction = Context.Database.BeginTransaction()) { try { var IsCountryExist = Context.MstAreaCode.Where(x => x.AreaCode == areaCode.AreaCode).FirstOrDefault(); if (IsCountryExist == null) { Context.MstAreaCode.Add(areaCode); } var IsCurrencyExist = Context.MstCurrency.Where(x => x.CurrencyCode == currency.CurrencyCode).FirstOrDefault(); if (IsCurrencyExist == null) { Context.MstCurrency.Add(currency); } Context.MstSite.Add(site); Context.MstFinYear.Add(finYear); Context.MstSiteCurrancyMap.Add(siteCurrency); Context.SaveChanges(); dbContextTransaction.Commit(); tranResult = true; } catch (DbEntityValidationException dbEx) { dbContextTransaction.Rollback(); foreach (DbEntityValidationResult entityErr in dbEx.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { Logging.Logger.Log("Error Property Name " + error.PropertyName + " : Error Message: " + error.ErrorMessage, Logging.Logger.LogingLevel.Error); Logging.Logger.Log(dbEx, Logging.Logger.LogingLevel.Error); } } } catch (Exception ex) { dbContextTransaction.Rollback(); Logging.Logger.Log(ex, Logging.Logger.LogingLevel.Error); throw ex; } } return(tranResult); }