public static List <StoreModel> GetQueryToSearchStore(CallCenterEntities dbEntities, string franchiseCode, AddressInfoModel model, out int franchiseId) { franchiseId = dbEntities.Franchise.Where(e => e.IsObsolete == false && e.Code == franchiseCode).Select(e => e.FranchiseId).Single(); var id = franchiseId; var query = dbEntities.StoreAddressDistribution.Where(e => e.FranchiseStore.FranchiseId == id); if (SettingsData.Store.ByCountry) { query = query.Where(e => e.CountryId == model.Country.IdKey); } if (SettingsData.Store.ByRegionA) { query = query.Where(e => e.RegionArId == model.RegionA.IdKey); } if (SettingsData.Store.ByRegionB) { query = query.Where(e => e.RegionBrId == model.RegionB.IdKey); } if (SettingsData.Store.ByRegionC) { query = query.Where(e => e.RegionCrId == model.RegionC.IdKey); } if (SettingsData.Store.ByRegionD) { query = query.Where(e => e.RegionDrId == model.RegionD.IdKey); } if (SettingsData.Store.ByZipCode) { query = query.Where(e => e.ZipCodeId == model.ZipCode.IdKey); } return(query.OrderByDescending(e => e.Importance).Select(e => new StoreModel { Key = e.FranchiseStoreId.ToString(), IdKey = e.FranchiseStoreId, Value = e.FranchiseStore.Name, MainAddress = e.FranchiseStore.Address.MainAddress, LstPhones = e.FranchiseStore.FranchisePhone.Select(i => i.Phone).ToList(), WsAddress = e.FranchiseStore.WsAddress }).ToList()); }
protected virtual void Dispose(bool disposing) { try { if (!disposing) { return; } if (DbConn != null) { DbConn.Dispose(); } } catch (Exception ex) { SharedLogger.LogError(ex); } finally { DbConn = null; } }
public ActionResult ZipCodes(string code) { try { using (var repository = new CallCenterEntities()) { var data = FactoryAddress.GetQueryToExecByZipCode(repository, code, true).ToList(); return(Json(new ResponseMessageModel { HasError = false, Data = data, })); } } catch (Exception ex) { SharedLogger.LogError(ex); return(Json(new ResponseMessageModel { HasError = false, Message = "Se presentó un problema al momento de consultar la información", })); } }
public AccountRepository(CallCenterEntities db) : base(db) { }
public UserRepository(CallCenterEntities dbConn) : base(dbConn) { }
protected BaseRepository(CallCenterEntities dbConn) { DbConn = dbConn; }
public MailManagement() { _entities = new CallCenterEntities(); }
public TelefonManagement() { _entities = new CallCenterEntities(); }
public StoreSettingService(CallCenterEntities callCenter) : this(new StoreRepository(callCenter), new AddressRepository(callCenter)) { }
protected BaseOneRepository(CallCenterEntities dbEntities) { DbEntities = dbEntities; }
protected BaseOneRepository() { DbEntities = new CallCenterEntities(); }
public MusteriManagement() { _entities = new CallCenterEntities(); }
public OrderRepository(CallCenterEntities dbEntities) : base(dbEntities) { }
public AdresManagement() { _entities = new CallCenterEntities(); }
public static IQueryable <AddressResponseSearch> GetQueryToExecByZipCode(CallCenterEntities dbEntities, String zipCode, bool startWith = false) { string regionChild = GetRegionChildByZipCode(); switch (regionChild) { case AddressConstants.REGION_A: { System.Linq.Expressions.Expression <Func <RegionA, bool> > linqExp; if (startWith) { linqExp = e => e.ZipCode.Code.StartsWith(zipCode); } else { linqExp = e => e.ZipCode.Code == zipCode; } return(dbEntities.RegionA.Where(linqExp).Select(e => new AddressResponseSearch { Country = new ListItemModel { IdKey = e.CountryId, Value = e.Country.Name }, RegionA = new ListItemModel { IdKey = e.RegionId, Value = e.Name }, ZipCode = new ListItemModel { IdKey = e.ZipCodeId, Value = e.ZipCode.Code } }).Take(50)); } case AddressConstants.REGION_B: { System.Linq.Expressions.Expression <Func <RegionB, bool> > linqExp; if (startWith) { linqExp = e => e.ZipCode.Code.StartsWith(zipCode); } else { linqExp = e => e.ZipCode.Code == zipCode; } return(dbEntities.RegionB.Where(linqExp).Select(e => new AddressResponseSearch { Country = new ListItemModel { IdKey = e.CountryId, Value = e.Country.Name }, RegionA = new ListItemModel { IdKey = e.RegionArId, Value = e.RegionA.Name }, RegionB = new ListItemModel { IdKey = e.RegionId, Value = e.Name }, ZipCode = new ListItemModel { IdKey = e.ZipCodeId, Value = e.ZipCode.Code } }).Take(50)); } case AddressConstants.REGION_C: { System.Linq.Expressions.Expression <Func <RegionC, bool> > linqExp; if (startWith) { linqExp = e => e.ZipCode.Code.StartsWith(zipCode); } else { linqExp = e => e.ZipCode.Code == zipCode; } return(dbEntities.RegionC.Where(linqExp).Select(e => new AddressResponseSearch { Country = new ListItemModel { IdKey = e.CountryId, Value = e.Country.Name }, RegionA = new ListItemModel { IdKey = e.RegionArId, Value = e.RegionA.Name }, RegionB = new ListItemModel { IdKey = e.RegionBrId, Value = e.RegionB.Name }, RegionC = new ListItemModel { IdKey = e.RegionId, Value = e.Name }, ZipCode = new ListItemModel { IdKey = e.ZipCodeId, Value = e.ZipCode.Code } }).Take(50)); } case AddressConstants.REGION_D: { System.Linq.Expressions.Expression <Func <RegionD, bool> > linqExp; if (startWith) { linqExp = e => e.ZipCode.Code.StartsWith(zipCode); } else { linqExp = e => e.ZipCode.Code == zipCode; } return(dbEntities.RegionD.Where(linqExp).Select(e => new AddressResponseSearch { Country = new ListItemModel { IdKey = e.CountryId, Value = e.Country.Name }, RegionA = new ListItemModel { IdKey = e.RegionArId, Value = e.RegionA.Name }, RegionB = new ListItemModel { IdKey = e.RegionBrId, Value = e.RegionB.Name }, RegionC = new ListItemModel { IdKey = e.RegionCrId, Value = e.RegionC.Name }, RegionD = new ListItemModel { IdKey = e.RegionId, Value = e.Name }, ZipCode = new ListItemModel { IdKey = e.ZipCodeId, Value = e.ZipCode.Code } }).Take(50)); } } throw new ArgumentNullException(String.Empty + "No está correctamente configurada la jerarquía de direcciones"); }
public static string GetIdByUsername(string username, CallCenterEntities dbEntities) { return(dbEntities.AspNetUsers.Where(e => e.UserName.Trim().ToLower() == username.Trim().ToLower()) .Select(e => e.Id).Single()); }
public ReportRepository(CallCenterEntities dbEntities) : base(dbEntities) { }
public FranchiseRepository(CallCenterEntities db) : base(db) { }
public GenericRepository(CallCenterEntities dbConnP) : base(dbConnP) { _dbSet = DbConn.Set(typeof(TEntity)); }
public AddressRepository(CallCenterEntities callCenter) : base(callCenter) { }
protected BaseRepository() { DbConn = new CallCenterEntities(); }
public StoreRepository(CallCenterEntities callCenter) : base(callCenter) { }