public static object GetByFilter(SessionInfo sessioninfo, string label, int jtStartIndex, int jtPageSize, string jtSorting) { try { CountryBusiness _countryBusiness = new CountryBusiness(); //Get data from database List <MA_COUNTRY> countries = _countryBusiness.GetByFilter(sessioninfo, label, jtSorting); //Return result to jTable return(new { Result = "OK", Records = jtPageSize > 0 ? countries.Skip(jtStartIndex).Take(jtPageSize).ToList() : countries, TotalRecordCount = countries.Count }); } catch (BusinessWorkflowsException bex) { return(new { Result = "ERROR", Message = bex.Message }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public void Update_SuccessfullyUpdatesCountry() { // Arrange var countries = new List <Country> { new Country { Name = "TestCountry1", Id = 1 }, new Country { Name = "TestCountry2", Id = 2 } }.AsQueryable(); var countrymockDbSet = new Mock <DbSet <Country> >(); countrymockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countrymockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countrymockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countrymockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countrymockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act countryBusiness.Update("UpdatedCountry", 1); // Assert mockContext.Verify(m => m.SaveChanges(), Times.Once()); }
public void AddCountry_SuccessfullyAddsACountry_WhenAllValuesAreCorrect() { // Arrange var countries = new List <Country>().AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(m => m.Countries).Returns(countryMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act countryBusiness.Add("TestCountry", 1); // Assert countryMockDbSet.Verify(m => m.Add(It.IsAny <Country>()), Times.Once()); mockContext.Verify(m => m.SaveChanges(), Times.Once()); }
public static object GetTempLimitByFilter(SessionInfo sessioninfo, string strCountry, string strEffDateFrom, string strEffDateTo , string strExpDateFrom, string strExpDateTo, int jtStartIndex, int jtPageSize, string jtSorting) { try { CountryBusiness _countryBusiness = new CountryBusiness(); //Get data from database List <MA_COUNTRY_LIMIT> limits = _countryBusiness.GetTempLimitByFilter(sessioninfo, strCountry, strEffDateFrom, strEffDateTo , strExpDateFrom, strExpDateTo, jtSorting); //Return result to jTable return(new { Result = "OK", Records = jtPageSize > 0 ? limits.Skip(jtStartIndex).Take(jtPageSize).ToList() : limits, TotalRecordCount = limits.Count }); } catch (BusinessWorkflowsException bex) { return(new { Result = "ERROR", Message = bex.Message }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object UpdateCountryLimit(SessionInfo sessioninfo, MA_COUNTRY_LIMIT record) { try { CountryBusiness _countryBusiness = new CountryBusiness(); if (!record.FLAG_CONTROL) { record.AMOUNT = 0; record.EFFECTIVE_DATE = sessioninfo.Process.CurrentDate; record.EXPIRY_DATE = sessioninfo.Process.CurrentDate; } record.LOG.MODIFYBYUSERID = sessioninfo.CurrentUserId; record.LOG.MODIFYDATE = DateTime.Now; var updateRecord = _countryBusiness.UpdateCountryLimit(sessioninfo, record); return(new { Result = "OK", Record = updateRecord }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public void GetAll_ReturnsAnEmptyList_WhenThereAreNoCountries() { // Arrange var countries = new List <Country>().AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act var allCountries = countryBusiness.GetAll(); // Assert int expectedCount = 0; Assert.AreEqual(expectedCount, allCountries.Count, "List of all countries is not empty"); }
public AllResponseCountry All() { var response = new AllResponseCountry(); var countryBussines = new CountryBusiness(); response.Result = countryBussines.ALL(); return(response); }
// The following methods are responsible for updating information when it is changed. /// <summary> /// Updates the user control every time it is loaded. /// </summary> public void UpdateUserControl() { var eazyCartContext = new EazyCartContext(); this.cityBusiness = new CityBusiness(eazyCartContext); this.countryBusiness = new CountryBusiness(eazyCartContext); this.categoryBusiness = new CategoryBusiness(eazyCartContext); this.supplierBusiness = new SupplierBusiness(eazyCartContext); this.ClearAndUpdateCategoryTab(); this.ClearAndUpdateCountryTab(); this.ClearAndUpdateCityTab(); this.ClearAndUpdateSupplierTab(); }
// The following methods are responsible for updating information when it is changed. /// <summary> /// Updates the user control every time it is loaded. /// </summary> public void UpdateUserControl() { var eazyCartContext = new EazyCartContext(); this.productBusiness = new ProductBusiness(eazyCartContext); this.categoryBusiness = new CategoryBusiness(eazyCartContext); this.supplierBusiness = new SupplierBusiness(eazyCartContext); this.unitBusiness = new UnitBusiness(eazyCartContext); this.countryBusiness = new CountryBusiness(eazyCartContext); this.cityBusiness = new CityBusiness(eazyCartContext); this.ClearAndUpdateProductTab(); this.ClearAndUpdateDeliveryTab(); }
public void Delete_ThrowsArgumentException_WhenCitiesAreRelatedToCountry() { // Arrange var countries = new List <Country> { new Country { Name = "TestCountry1", Id = 1 }, }.AsQueryable(); var cities = new List <City> { new City { Name = "TestCity", Id = 1, CountryId = 1 } }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var cityMockDbSet = new Mock <DbSet <City> >(); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.GetEnumerator()).Returns(cities.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); mockContext.Setup(c => c.Cities).Returns(cityMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act try { int idToDelete = 1; countryBusiness.Delete(idToDelete); Assert.Fail("No exception was thrown."); } catch (ArgumentException exc) { string expectedMessage = "One or more cities are related to this country."; Assert.AreEqual(expectedMessage, exc.Message, "Another exception was thrown."); } }
public ServicesLocalizationController(UserManager <ApplicationUser> userManager, IHttpContextAccessor httpContextAccessor, MardisContext mardisContext, ILogger <ServicesLocalizationController> logger, ILogger <ServicesFilterController> loggeFilter, IMemoryCache memoryCache) : base(userManager, httpContextAccessor, mardisContext, logger) { countryBusiness = new CountryBusiness(mardisContext, memoryCache); provinceBusiness = new ProvinceBusiness(mardisContext, memoryCache); districtBusiness = new DistrictBusiness(mardisContext); parishBusiness = new ParishBusiness(mardisContext); sectorBusiness = new SectorBusiness(mardisContext); }
public void Delete_DeletesCountriesSuccessfully_WhenNoCitiesAreRelatedToCountry() { // Arrange var countries = new List <Country> { new Country { Name = "TestCountry1", Id = 1 }, new Country { Name = "TestCountry2", Id = 2 }, }.AsQueryable(); var cities = new List <City> { new City { Name = "TestCity", Id = 1, CountryId = 1 } }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var cityMockDbSet = new Mock <DbSet <City> >(); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.GetEnumerator()).Returns(cities.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); mockContext.Setup(c => c.Cities).Returns(cityMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act int idToDelete = 2; countryBusiness.Delete(idToDelete); // Assert countryMockDbSet.Verify(x => x.Remove(It.IsAny <Country>()), Times.Once); mockContext.Verify(x => x.SaveChanges(), Times.Once); }
public static object Update(SessionInfo sessioninfo, MA_COUNTRY record) { try { CountryBusiness _countryBusiness = new CountryBusiness(); record.LABEL = record.LABEL.ToUpper(); record.DESCRIPTION = record.DESCRIPTION.ToUpper(); var updateRecord = _countryBusiness.Update(sessioninfo, record); return(new { Result = "OK", Record = updateRecord }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object UpdateTempLimit(SessionInfo sessioninfo, MA_COUNTRY_LIMIT record) { try { CountryBusiness _countryBusiness = new CountryBusiness(); record.LOG.MODIFYDATE = DateTime.Now; record.LOG.MODIFYBYUSERID = sessioninfo.CurrentUserId; var updateRecord = _countryBusiness.UpdateTempCountryLimit(sessioninfo, record); return(new { Result = "OK", Record = updateRecord }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public static object GetCountryOptions(SessionInfo sessioninfo) { try { CountryBusiness _countryBusiness = new CountryBusiness(); //Get data from database var countries = _countryBusiness.GetCountryAll() .OrderBy(p => p.LABEL) .Select(c => new { DisplayText = c.LABEL, Value = c.ID }); //Return result to jTable return(new { Result = "OK", Options = countries }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public void Remove(int id) { try { var bc = new CountryBusiness(); bc.Remove(id); } catch (Exception ex) { var httpError = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, ReasonPhrase = ex.Message }; throw new HttpResponseException(httpError); } }
public Country Add(Country country) { try { var bc = new CountryBusiness(); return(bc.Add(country)); } catch (Exception ex) { var httpError = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, ReasonPhrase = ex.Message }; throw new HttpResponseException(httpError); } }
public void Edit(Country country) { try { var bc = new CountryBusiness(); country.ChangedOn = System.DateTime.Now; bc.Edit(country); } catch (Exception ex) { var httpError = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, ReasonPhrase = ex.Message }; throw new HttpResponseException(httpError); } }
public FindResponseCountry Find(int id) { try { var response = new FindResponseCountry(); var bc = new CountryBusiness(); response.Result = bc.Find(id); return(response); } catch (Exception ex) { var httpError = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, ReasonPhrase = ex.Message }; throw new HttpResponseException(httpError); } }
public AllResponse <Country> All() { try { var response = new AllResponse <Country>(); var bc = new CountryBusiness(); response.Result = bc.All(); return(response); } catch (Exception ex) { var httpError = new HttpResponseMessage() { StatusCode = (HttpStatusCode)422, ReasonPhrase = ex.Message }; throw new HttpResponseException(httpError); } }
public static object GetCountryLimitByCountryID(SessionInfo sessioninfo, Guid ID) { try { CountryBusiness _countryBusiness = new CountryBusiness(); //Get data from database List <MA_COUNTRY_LIMIT> limits = _countryBusiness.GetCountryLimitByCountryID(sessioninfo, ID); //Return result to jTable return(new { Result = "OK", Records = limits, TotalRecordCount = limits.Count }); } catch (BusinessWorkflowsException bex) { return(new { Result = "ERROR", Message = bex.Message }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public void GetAll_ReturnsACorrectListOfCountries_WhenThereAreCountries() { // Arrange var countries = new List <Country> { new Country { Name = "TestCountry1", Id = 1 }, new Country { Name = "TestCountry2", Id = 2 }, new Country { Name = "TestCountry3", Id = 3 }, }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act var allCountries = countryBusiness.GetAll(); // Assert string expectedFirstCountryName = "TestCountry1"; string expectedSecondCountryName = "TestCountry2"; string expectedThirdCountryName = "TestCountry3"; Assert.AreEqual(expectedFirstCountryName, allCountries[0].Name, "First names do not match."); Assert.AreEqual(expectedSecondCountryName, allCountries[1].Name, "Second names do not match."); Assert.AreEqual(expectedThirdCountryName, allCountries[2].Name, "Third names do not match"); }
public static object CreateTempLimit(SessionInfo sessioninfo, MA_COUNTRY_LIMIT record) { try { CountryBusiness _countryBusiness = new CountryBusiness(); record.ID = Guid.NewGuid(); record.ISTEMP = true; record.FLAG_CONTROL = true; record.LOG.INSERTDATE = DateTime.Now; record.LOG.INSERTBYUSERID = sessioninfo.CurrentUserId; var addedRecord = _countryBusiness.CreateTempLimit(sessioninfo, record); return(new { Result = "OK", Record = addedRecord }); } catch (Exception ex) { return(new { Result = "ERROR", Message = ex.Message }); } }
public void GetCountry_ReturnsACountry_WhichIsNotNull() { // Arrange var countries = new List <Country> { new Country { Name = "TestCountry1", Id = 1 }, new Country { Name = "TestCountry2", Id = 2 }, new Country { Name = "TestCountry3", Id = 3 }, }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act int idToGet = 2; var country = countryBusiness.Get(idToGet); // Assert string expectedCountryName = "TestCountry2"; Assert.IsNotNull(country, "Country could not be extracted."); Assert.AreEqual(expectedCountryName, country.Name, "Names do not match."); }
public BranchController(UserManager <ApplicationUser> userManager, IHttpContextAccessor httpContextAccessor, MardisContext mardisContext, ILogger <BranchController> logger, ILogger <ServicesFilterController> loggeFilter, IMemoryCache memoryCache, RedisCache distributedCache) : base(userManager, httpContextAccessor, mardisContext, logger) { TableName = CBranch.TableName; ControllerName = CBranch.Controller; _cache = memoryCache; _branchBusiness = new BranchBusiness(mardisContext); _branchImageBusiness = new BranchImageBusiness(mardisContext); _taskCampaignBusiness = new TaskCampaignBusiness(mardisContext, distributedCache); _countryBusiness = new CountryBusiness(mardisContext, memoryCache); _provinceBusiness = new ProvinceBusiness(mardisContext, memoryCache); _districtBusiness = new DistrictBusiness(mardisContext); _parishBusiness = new ParishBusiness(mardisContext); _sectorBusiness = new SectorBusiness(mardisContext); _smsBusiness = new SmsBusiness(mardisContext); }
public void AddCountry_ThrowsArgumentException_WhenIdIsDuplicate() { // Arrange int duplicateId = 1; var countries = new List <Country> { new Country { Name = "TestCountry1", Id = duplicateId }, }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); mockContext.Setup(c => c.SaveChanges()).Throws(new Exception()); var countryBusiness = new CountryBusiness(mockContext.Object); // Act & Assert try { countryBusiness.Add("TestCountry1", duplicateId); Assert.Fail("No exception was thrown"); } catch (ArgumentException exc) { string expectedMessage = string.Format("Country with ID {0} already exists.", duplicateId); Assert.AreEqual(expectedMessage, exc.Message, "Wrong exception is thrown"); } }
public static void Initialize(CSCDbContext dbContext) { dbContext.Database.EnsureCreated(); if (dbContext.Users.Any()) { return; } var users = new User[] { new User { Name = "Michael", Surname = "Jackson", Email = "*****@*****.**", Address = "Indiana", Password = "******" }, new User { Name = "Arnold", Surname = "Schwarzenegger", Email = "*****@*****.**", Address = "Los Angeles", Password = "******" } }; foreach (var user in users) { dbContext.Users.Add(user); } dbContext.SaveChanges(); var organizations = new Organization[] { new Organization { Name = "Samsung", Code = "S7", Type = OrganizationType.GeneralPartnership, User = users[0] }, new Organization { Name = "Vodafone", Code = "V8", Type = OrganizationType.IncorporatedCompany, User = users[0] }, new Organization { Name = "T-Mobile", Code = "TMB", Type = OrganizationType.LimitedLiabilityCompany, User = users[1] }, new Organization { Name = "AT&T branded", Code = "ATT", Type = OrganizationType.LimitedPartnership, User = users[1] }, new Organization { Name = "XAS", Code = "XAS", Type = OrganizationType.SocialEnterprise, User = users[1] } }; foreach (var organization in organizations) { dbContext.Organizations.Add(organization); } dbContext.SaveChanges(); var countries = new Country[] { new Country { Name = "Afghanistan", Code = "AFG", Organization = organizations[0] }, new Country { Name = "Austria", Code = "TRG", Organization = organizations[0] }, new Country { Name = "Bulgaria", Code = "BGL", Organization = organizations[0] }, new Country { Name = "Croatia", Code = "CRO", Organization = organizations[0] }, new Country { Name = "Cyprus", Code = "CYY", Organization = organizations[4] }, new Country { Name = "Czech Republic", Code = "ETL", Organization = organizations[2] }, new Country { Name = "Greece", Code = "EUR", Organization = organizations[1] }, new Country { Name = "Hungary", Code = "XEH", Organization = organizations[3] }, new Country { Name = "Indonesia", Code = "XSE", Organization = organizations[4] }, new Country { Name = "Israel", Code = "ILO", Organization = organizations[2] }, new Country { Name = "Italy", Code = "ITV", Organization = organizations[1] }, new Country { Name = "Libya", Code = "BTC", Organization = organizations[3] }, new Country { Name = "Luxembourg", Code = "LUX", Organization = organizations[2] }, new Country { Name = "Montenegro", Code = "TMT", Organization = organizations[3] } }; foreach (var country in countries) { dbContext.Countries.Add(country); } dbContext.SaveChanges(); var businessTypes = new Business[] { new Business { Name = "GIS" }, new Business { Name = "CEO" }, new Business { Name = "Telecommunication" }, new Business { Name = "Managed Services" } }; foreach (var businessType in businessTypes) { dbContext.Businesses.Add(businessType); } dbContext.SaveChanges(); var familyTypes = new Family[] { new Family { Name = "Data Center", Business = businessTypes[0] }, new Family { Name = "Cloud", Business = businessTypes[0] }, new Family { Name = "Cyber", Business = businessTypes[1] }, new Family { Name = "Computer Networks", Business = businessTypes[2] }, new Family { Name = "Television Networks", Business = businessTypes[2] }, new Family { Name = "Business-to-business", Business = businessTypes[3] }, new Family { Name = "Marketing", Business = businessTypes[3] } }; foreach (var familyType in familyTypes) { dbContext.Families.Add(familyType); } dbContext.SaveChanges(); var offeringTypes = new Offering[] { new Offering { Name = "Data Storage", Family = familyTypes[0] }, new Offering { Name = "Data management", Family = familyTypes[0] }, new Offering { Name = "Biz cloud", Family = familyTypes[1] }, new Offering { Name = "Cloud compute", Family = familyTypes[1] }, new Offering { Name = "Consulting services", Family = familyTypes[2] }, new Offering { Name = "Ethernet", Family = familyTypes[3] }, new Offering { Name = "Wireless networks", Family = familyTypes[3] }, new Offering { Name = "Cable television", Family = familyTypes[4] }, new Offering { Name = "Satellite television", Family = familyTypes[4] }, new Offering { Name = "Supply chain management", Family = familyTypes[5] }, new Offering { Name = "Videoconferencing", Family = familyTypes[5] }, new Offering { Name = "Marketing strategy", Family = familyTypes[6] }, new Offering { Name = "Integrated advertising agency services", Family = familyTypes[6] } }; foreach (var offeringType in offeringTypes) { dbContext.Offerings.Add(offeringType); } dbContext.SaveChanges(); var countryBusinesses = new CountryBusiness[] { new CountryBusiness { Country = countries[0], Business = businessTypes[0] }, new CountryBusiness { Country = countries[1], Business = businessTypes[0] }, new CountryBusiness { Country = countries[1], Business = businessTypes[1] }, new CountryBusiness { Country = countries[2], Business = businessTypes[2] }, new CountryBusiness { Country = countries[3], Business = businessTypes[3] }, new CountryBusiness { Country = countries[3], Business = businessTypes[1] }, new CountryBusiness { Country = countries[4], Business = businessTypes[2] }, new CountryBusiness { Country = countries[5], Business = businessTypes[3] }, new CountryBusiness { Country = countries[6], Business = businessTypes[0] }, new CountryBusiness { Country = countries[6], Business = businessTypes[2] }, new CountryBusiness { Country = countries[6], Business = businessTypes[1] }, new CountryBusiness { Country = countries[8], Business = businessTypes[3] }, new CountryBusiness { Country = countries[9], Business = businessTypes[0] }, new CountryBusiness { Country = countries[9], Business = businessTypes[3] }, new CountryBusiness { Country = countries[10], Business = businessTypes[2] }, new CountryBusiness { Country = countries[12], Business = businessTypes[1] }, new CountryBusiness { Country = countries[12], Business = businessTypes[0] }, new CountryBusiness { Country = countries[12], Business = businessTypes[2] }, new CountryBusiness { Country = countries[13], Business = businessTypes[3] } }; foreach (var countryBusiness in countryBusinesses) { dbContext.CountryBusinesses.Add(countryBusiness); } dbContext.SaveChanges(); var businessFamilies = new BusinessFamily[] { new BusinessFamily { CountryBusiness = countryBusinesses[0], Family = familyTypes[0] }, new BusinessFamily { CountryBusiness = countryBusinesses[0], Family = familyTypes[1] }, new BusinessFamily { CountryBusiness = countryBusinesses[1], Family = familyTypes[1] }, new BusinessFamily { CountryBusiness = countryBusinesses[2], Family = familyTypes[2] }, new BusinessFamily { CountryBusiness = countryBusinesses[3], Family = familyTypes[3] }, new BusinessFamily { CountryBusiness = countryBusinesses[4], Family = familyTypes[5] }, new BusinessFamily { CountryBusiness = countryBusinesses[4], Family = familyTypes[6] }, new BusinessFamily { CountryBusiness = countryBusinesses[6], Family = familyTypes[3] }, new BusinessFamily { CountryBusiness = countryBusinesses[7], Family = familyTypes[6] }, new BusinessFamily { CountryBusiness = countryBusinesses[8], Family = familyTypes[0] }, new BusinessFamily { CountryBusiness = countryBusinesses[9], Family = familyTypes[3] }, new BusinessFamily { CountryBusiness = countryBusinesses[9], Family = familyTypes[4] }, new BusinessFamily { CountryBusiness = countryBusinesses[11], Family = familyTypes[5] }, new BusinessFamily { CountryBusiness = countryBusinesses[12], Family = familyTypes[1] }, new BusinessFamily { CountryBusiness = countryBusinesses[13], Family = familyTypes[6] }, new BusinessFamily { CountryBusiness = countryBusinesses[14], Family = familyTypes[3] }, new BusinessFamily { CountryBusiness = countryBusinesses[14], Family = familyTypes[4] }, new BusinessFamily { CountryBusiness = countryBusinesses[16], Family = familyTypes[0] }, new BusinessFamily { CountryBusiness = countryBusinesses[17], Family = familyTypes[4] }, new BusinessFamily { CountryBusiness = countryBusinesses[18], Family = familyTypes[5] } }; foreach (var businessFamily in businessFamilies) { dbContext.BusinessFamilies.Add(businessFamily); } dbContext.SaveChanges(); var familyOfferings = new FamilyOffering[] { new FamilyOffering { BusinessFamily = businessFamilies[0], Offering = offeringTypes[0] }, new FamilyOffering { BusinessFamily = businessFamilies[1], Offering = offeringTypes[2] }, new FamilyOffering { BusinessFamily = businessFamilies[2], Offering = offeringTypes[3] }, new FamilyOffering { BusinessFamily = businessFamilies[3], Offering = offeringTypes[4] }, new FamilyOffering { BusinessFamily = businessFamilies[5], Offering = offeringTypes[9] }, new FamilyOffering { BusinessFamily = businessFamilies[5], Offering = offeringTypes[10] }, new FamilyOffering { BusinessFamily = businessFamilies[6], Offering = offeringTypes[11] }, new FamilyOffering { BusinessFamily = businessFamilies[7], Offering = offeringTypes[5] }, new FamilyOffering { BusinessFamily = businessFamilies[8], Offering = offeringTypes[11] }, new FamilyOffering { BusinessFamily = businessFamilies[8], Offering = offeringTypes[12] }, new FamilyOffering { BusinessFamily = businessFamilies[10], Offering = offeringTypes[6] }, new FamilyOffering { BusinessFamily = businessFamilies[11], Offering = offeringTypes[7] }, new FamilyOffering { BusinessFamily = businessFamilies[12], Offering = offeringTypes[9] }, new FamilyOffering { BusinessFamily = businessFamilies[13], Offering = offeringTypes[2] }, new FamilyOffering { BusinessFamily = businessFamilies[13], Offering = offeringTypes[3] }, new FamilyOffering { BusinessFamily = businessFamilies[15], Offering = offeringTypes[5] }, new FamilyOffering { BusinessFamily = businessFamilies[16], Offering = offeringTypes[8] }, new FamilyOffering { BusinessFamily = businessFamilies[17], Offering = offeringTypes[1] }, new FamilyOffering { BusinessFamily = businessFamilies[18], Offering = offeringTypes[7] }, new FamilyOffering { BusinessFamily = businessFamilies[18], Offering = offeringTypes[8] }, new FamilyOffering { BusinessFamily = businessFamilies[19], Offering = offeringTypes[10] } }; foreach (var familyOffering in familyOfferings) { dbContext.FamilyOfferings.Add(familyOffering); } dbContext.SaveChanges(); var departments = new Department[] { new Department { Name = "Departmetnt 1", FamilyOffering = familyOfferings[0] }, new Department { Name = "Departmetnt 2", FamilyOffering = familyOfferings[1] }, new Department { Name = "Departmetnt 3", FamilyOffering = familyOfferings[1] }, new Department { Name = "Departmetnt 4", FamilyOffering = familyOfferings[2] }, new Department { Name = "Departmetnt 5", FamilyOffering = familyOfferings[2] }, new Department { Name = "Departmetnt 6", FamilyOffering = familyOfferings[2] }, new Department { Name = "Departmetnt 7", FamilyOffering = familyOfferings[4] }, new Department { Name = "Departmetnt 8", FamilyOffering = familyOfferings[5] }, new Department { Name = "Departmetnt 9", FamilyOffering = familyOfferings[6] }, new Department { Name = "Departmetnt 10", FamilyOffering = familyOfferings[7] }, new Department { Name = "Departmetnt 11", FamilyOffering = familyOfferings[7] }, new Department { Name = "Departmetnt 12", FamilyOffering = familyOfferings[7] }, new Department { Name = "Departmetnt 13", FamilyOffering = familyOfferings[9] }, new Department { Name = "Departmetnt 14", FamilyOffering = familyOfferings[10] }, new Department { Name = "Departmetnt 15", FamilyOffering = familyOfferings[11] }, new Department { Name = "Departmetnt 16", FamilyOffering = familyOfferings[11] }, new Department { Name = "Departmetnt 17", FamilyOffering = familyOfferings[13] }, new Department { Name = "Departmetnt 18", FamilyOffering = familyOfferings[14] }, new Department { Name = "Departmetnt 19", FamilyOffering = familyOfferings[15] }, new Department { Name = "Departmetnt 20", FamilyOffering = familyOfferings[17] }, new Department { Name = "Departmetnt 21", FamilyOffering = familyOfferings[17] }, new Department { Name = "Departmetnt 22", FamilyOffering = familyOfferings[17] }, new Department { Name = "Departmetnt 23", FamilyOffering = familyOfferings[19] }, new Department { Name = "Departmetnt 24", FamilyOffering = familyOfferings[20] }, new Department { Name = "Departmetnt 25", FamilyOffering = familyOfferings[20] } }; foreach (var department in departments) { dbContext.Departments.Add(department); } dbContext.SaveChanges(); }
public List <LimitAuditReportModel> GetLimitAuditReport(SessionInfo sessionInfo, string strLogDatefrom, string strLogDateto, string strCtpy, string strCountry, string strEvent) { try { DateTime dteReportfrom; DateTime dteReportto; Guid guCtpyID = Guid.Empty; Guid guCountryID = Guid.Empty; LogBusiness _logBusiness = new LogBusiness(); CounterpartyBusiness _counterpartyBusiness = new CounterpartyBusiness(); CountryBusiness _countryBusiness = new CountryBusiness(); UserBusiness _userBusiness = new UserBusiness(); var log = _logBusiness.GetLogAll().Where(l => l.EVENT == LimitLogEvent.LIMIT_AUDIT.ToString() || l.EVENT == LimitLogEvent.TEMP_LIMIT_AUDIT.ToString() || l.EVENT == LimitLogEvent.COUNTRY_LIMIY_AUDIT.ToString() || l.EVENT == LimitLogEvent.TEMP_COUNTRY_LIMIT_AUDIT.ToString()).AsQueryable(); var ctpyLimit = _counterpartyBusiness.GetCounterpartyLimitAll().AsQueryable(); var ctpys = _counterpartyBusiness.GetCounterpartyAll().AsQueryable(); var countrys = _countryBusiness.GetCountryAll().AsQueryable(); var users = _userBusiness.GetAll().AsQueryable(); if (String.IsNullOrEmpty(strLogDatefrom)) { throw this.CreateException(new Exception(), "Please input start log date."); } else if (!DateTime.TryParseExact(strLogDatefrom, "dd/MM/yyyy", null, DateTimeStyles.None, out dteReportfrom)) { throw this.CreateException(new Exception(), "Invalid start log date."); } else { dteReportfrom = DateTime.ParseExact(strLogDatefrom, "dd/MM/yyyy", null); } if (String.IsNullOrEmpty(strLogDateto)) { throw this.CreateException(new Exception(), "Please input end log date."); } else if (!DateTime.TryParseExact(strLogDateto, "dd/MM/yyyy", null, DateTimeStyles.None, out dteReportto)) { throw this.CreateException(new Exception(), "Invalid end log date."); } else { dteReportto = DateTime.ParseExact(strLogDateto, "dd/MM/yyyy", null); } if (dteReportto < dteReportfrom) { throw this.CreateException(new Exception(), "Start log date must before end log date."); } var limits = from limit in ctpyLimit join ctpy in ctpys on limit.CTPY_ID equals ctpy.ID select new { LIMIT_ID = limit.ID, CTPY_ID = ctpy.ID, SNAME = ctpy.SNAME, LIMIT = limit.MA_LIMIT.LABEL }; log = log.Where(l => l.LOG_DATE.Date >= dteReportfrom.Date && l.LOG_DATE.Date <= dteReportto.Date); if (strEvent != "-1") { log = log.Where(p => p.EVENT == strEvent); } var limitAudits = from l in log join user in users on l.LOG.INSERTBYUSERID equals user.ID join c in limits on l.RECORD_ID equals c.LIMIT_ID into templimit from sublimit in templimit.DefaultIfEmpty() join country in countrys on l.RECORD_ID equals country.ID into tempcountry from subcountry in tempcountry.DefaultIfEmpty() orderby l.LOG_DATE select new LimitAuditReportModel { ENTITY = sublimit != null ? sublimit.SNAME : subcountry != null ? subcountry.LABEL : "", ENTITY_ID = sublimit != null ? sublimit.CTPY_ID : (subcountry != null ? subcountry.ID : Guid.Empty), LIMIT = (l.EVENT.Contains("TEMP") ? "TEMP-" : "") + (sublimit != null ? sublimit.LIMIT : "COUNTRY-LIMIT"), //sublimit != null ? sublimit.LIMIT : "Country Limit", USER = user.USERCODE, LOG_DATE = l.LOG_DATE, LOG_DATE_STR = l.LOG_DATE.ToString("dd-MMM-yyyy HH:mm"), DETAIL = l.LOG_DETAIL }; if (Guid.TryParse(strCtpy, out guCtpyID)) { guCtpyID = Guid.Parse(strCtpy); limitAudits = limitAudits.Where(p => p.ENTITY_ID == guCtpyID); } if (Guid.TryParse(strCountry, out guCountryID)) { guCountryID = Guid.Parse(strCountry); limitAudits = limitAudits.Where(t => t.ENTITY_ID == guCountryID); } return(limitAudits.ToList()); } catch (DataServicesException ex) { throw this.CreateException(ex, null); } }
public List <LimitCheckModel> GetCountryReport(SessionInfo sessioninfo, string strReportDate, string strCountry, string strSource, string strStatus) { try { DateTime dteReport; LimitCheckBusiness _limitBusiness = new LimitCheckBusiness(); DealBusiness _dealBusiness = new DealBusiness(); CounterpartyBusiness _counterpartyBusiness = new CounterpartyBusiness(); CountryBusiness _countryBusiness = new CountryBusiness(); Guid guCountryID = Guid.Empty; MA_COUNTRY_LIMIT temp_limit = null; if (String.IsNullOrEmpty(strReportDate)) { throw this.CreateException(new Exception(), "Please input report date."); } else if (!DateTime.TryParseExact(strReportDate, "dd/MM/yyyy", null, DateTimeStyles.None, out dteReport)) { throw this.CreateException(new Exception(), "Invalid report date."); } else { dteReport = DateTime.ParseExact(strReportDate, "dd/MM/yyyy", null); } if (_dealBusiness.CountByProcessDate(dteReport) == 0) { throw this.CreateException(new Exception(), "No data for selected report date."); } if (Guid.TryParse(strCountry, out guCountryID)) { guCountryID = Guid.Parse(strCountry); } List <LimitCheckModel> sets = _limitBusiness.GetCountrySETByCriteria(dteReport, guCountryID, strSource, Guid.Empty, Guid.Empty); List <LimitCheckModel> pces = _limitBusiness.GetCountryPCEByCriteria(dteReport, guCountryID, strSource, Guid.Empty, Guid.Empty); var reports = (from report in sets.Union(pces) join pce in pces on report.COUNTRY_ID equals pce.COUNTRY_ID select new LimitCheckModel { COUNTRY_LABEL = report.COUNTRY_LABEL, COUNTRY_ID = report.COUNTRY_ID, FLAG_CONTROL = report.FLAG_CONTROL, GEN_AMOUNT = report.AMOUNT, PROCESSING_DATE = report.PROCESSING_DATE, EXPIRE_DATE = report.EXPIRE_DATE, FLOW_DATE = report.FLOW_DATE, SET_CONTRIBUTE = report.SET_CONTRIBUTE, PCE_CONTRIBUTE = pce.PCE_CONTRIBUTE }).GroupBy(g => new { g.COUNTRY_ID, g.COUNTRY_LABEL, g.FLAG_CONTROL, g.GEN_AMOUNT, g.PROCESSING_DATE, g.EXPIRE_DATE, g.FLOW_DATE, g.PCE_CONTRIBUTE }).Select(s => new LimitCheckModel { COUNTRY_LABEL = s.Key.COUNTRY_LABEL, COUNTRY_ID = s.Key.COUNTRY_ID, FLAG_CONTROL = s.Key.FLAG_CONTROL, GEN_AMOUNT = s.Key.GEN_AMOUNT, PROCESSING_DATE = s.Key.PROCESSING_DATE, EXPIRE_DATE = s.Key.EXPIRE_DATE, FLOW_DATE = s.Key.FLOW_DATE, PCE_CONTRIBUTE = s.Key.PCE_CONTRIBUTE, SET_CONTRIBUTE = s.Sum(x => x.SET_CONTRIBUTE), ORIGINAL_KK_CONTRIBUTE = s.Key.PCE_CONTRIBUTE + s.Sum(y => y.SET_CONTRIBUTE) }).ToList(); foreach (var report in reports) { temp_limit = _countryBusiness.GetActiveTempByCountryID(sessioninfo.Process.CurrentDate, report.FLOW_DATE, report.COUNTRY_ID); if (temp_limit != null) { report.TEMP_AMOUNT = temp_limit.AMOUNT; } } if (strStatus != "") { reports = reports.Where(t => t.STATUS.IndexOf(strStatus, StringComparison.OrdinalIgnoreCase) >= 0).ToList(); } return(reports.OrderBy(p => p.COUNTRY_LABEL).ThenBy(t => t.FLOW_DATE).ToList()); } catch (DataServicesException ex) { throw this.CreateException(ex, null); } }
public void GetNameBySupplier_ReturnsACorrectCountry() { // Arrange var countries = new List <Country>() { new Country() { Id = 1, Name = "TestCountry1" }, new Country() { Id = 2, Name = "TestCountry2" }, }.AsQueryable(); var cities = new List <City>() { new City() { Id = 1, Name = "TestCity1", CountryId = 1 }, new City() { Id = 2, Name = "TestCity2", CountryId = 2 }, }.AsQueryable(); var suppliers = new List <Supplier>() { new Supplier() { Id = 1, Name = "TestSupplier1", CityId = 1 }, new Supplier() { Id = 2, Name = "TestSupplier2", CityId = 2 }, }.AsQueryable(); var countryMockDbSet = new Mock <DbSet <Country> >(); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Provider).Returns(countries.Provider); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.Expression).Returns(countries.Expression); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.ElementType).Returns(countries.ElementType); countryMockDbSet.As <IQueryable <Country> >().Setup(m => m.GetEnumerator()).Returns(countries.GetEnumerator()); var cityMockDbSet = new Mock <DbSet <City> >(); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Provider).Returns(cities.Provider); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.Expression).Returns(cities.Expression); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.ElementType).Returns(cities.ElementType); cityMockDbSet.As <IQueryable <City> >().Setup(m => m.GetEnumerator()).Returns(cities.GetEnumerator()); var supplierMockDbSet = new Mock <DbSet <Supplier> >(); supplierMockDbSet.As <IQueryable <Supplier> >().Setup(m => m.Provider).Returns(suppliers.Provider); supplierMockDbSet.As <IQueryable <Supplier> >().Setup(m => m.Expression).Returns(suppliers.Expression); supplierMockDbSet.As <IQueryable <Supplier> >().Setup(m => m.ElementType).Returns(suppliers.ElementType); supplierMockDbSet.As <IQueryable <Supplier> >().Setup(m => m.GetEnumerator()).Returns(suppliers.GetEnumerator()); var mockContext = new Mock <EazyCartContext>(); mockContext.Setup(c => c.Countries).Returns(countryMockDbSet.Object); mockContext.Setup(c => c.Cities).Returns(cityMockDbSet.Object); mockContext.Setup(c => c.Suppliers).Returns(supplierMockDbSet.Object); var countryBusiness = new CountryBusiness(mockContext.Object); // Act string supplierName = "TestSupplier1"; string actualCountryName = countryBusiness.GetNameBySupplier(supplierName); // Assert string expectedCountryName = "TestCountry1"; Assert.AreEqual(expectedCountryName, actualCountryName, "Country names do not match."); }