protected void Page_Load(object sender, EventArgs e) { // cldDateOfBirth.Visible = false; if (!IsPostBack) { int VendorId = 0; string id = Convert.ToString(Request.QueryString["VendorId"]); // if (id != null) { btnVendorUpdate.Visible = true; btnVendorAdd.Visible = false; VendorId = Convert.ToInt32(id); VendorRepository VenRep = new VendorRepository(); VendorObject VenObj = VenRep.GetById(VendorId); hdnMsgId.Value = VenObj.MsgId.ToString(); txtDisplayMsg.Text = VenObj.DisplayMsg; txtMsg_Title.Text = VenObj.Msg_Title; txtFull_Message.Text = VenObj.Full_Message; } else { btnVendorUpdate.Visible = false; btnVendorAdd.Visible = true; } } }
public void Update(RegisterViewModel model) { using (var db = new VendorRepository()) { db.Update(ConvertToVendor(model)); } }
public void RetrieveAllTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor>(); expected.Add(new Vendor() { VendorId = 22, CompanyName = "Amalgamated Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 35, CompanyName = "Car Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 28, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 42, CompanyName = "Toys for Fun", Email = "*****@*****.**" }); // Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Toy")).OrderBy(v => v.CompanyName); // Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
protected void grdVendorList_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "VendorCmdDelete": { int VendorId = Convert.ToInt32(e.CommandArgument); VendorRepository VenObj = new VendorRepository(); VenObj.Delete(VendorId); List <VendorObject> VendorList = new List <VendorObject>(); VendorList = VenObj.GetAll(); grdVendorList.DataSource = VendorList; grdVendorList.DataBind(); break; } default: { break; } } }
public static int UpdateVendor(Vendor vendor) { if (vendor == null) { throw new System.ArgumentNullException() { Source = "vendor" }; } using (CustomClearviewEntities ctx = new CustomClearviewEntities()) { VendorRepository repo = new VendorRepository(ctx); Vendor v = GetVendor(vendor.VendorId); v.VendorId = vendor.VendorId; v.VendorName = vendor.VendorName; v.VendorNumber = vendor.VendorNumber; v.SalesChannelId = vendor.SalesChannelId; v.CommissionNumber = vendor.CommissionNumber; v.IsActive = vendor.IsActive; v.ModifiedBy = vendor.ModifiedBy; v.ModifiedDateTime = vendor.ModifiedDateTime; v.SalesChannel = null; repo.Update(v); ctx.SaveChanges(); } return(vendor.VendorId); }
public void SendEmailTestAdd() { //arrange var vendorReposirory = new VendorRepository(); var vendorsCollection = vendorReposirory.Retrieve(); //vendorsCollection.Add(new Vendor() { VendorId = 27, CompanyName = "Aidas Inc" }); //kai pakeiciau return type i Ienumerable neleidzia naudot add metodo //prevencija read only. nes add pakeicia retrievinama colekcija //var vendorMaster = vendorReposirory.Retrieve(); var expected = new List <string>() { "Message sent: Important message for: ACB", "Message sent: Important message for: ZXC"//, //"Message sent: Important message for: Aidas Inc" }; var vendors = vendorsCollection.ToList(); Console.WriteLine(vendors.Count); //actual var actual = Vendor.SendEmail(vendors, "Test Message"); //assert CollectionAssert.AreEqual(expected, actual); }
public void CrudTest() { var target = new VendorRepository(); foreach (var v in good) { target.Add(v); // create Assert.IsTrue(v.Id > 0); v.Nome = "Updated"; target.Update(v); // update target.Remove(v); // remove } foreach (var v in bad) { try { target.Add(v); // create target.Remove(v); // remove Assert.Fail("Should had thrown a validation exception!"); } catch (Exception e) { Assert.IsInstanceOfType(e, typeof(ValidationException)); } } }
public UnitOfWork(SCMSContext context) { _context = context; Inventories = new InventoryRepository(_context); Items = new ItemRepository(_context); Vendors = new VendorRepository(_context); }
public void RetrieveTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 1, CompanyName = "ABC Corp", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 2, CompanyName = "XYZ Inc", Email = "*****@*****.**" } } }; //Act var vendorIterator = repository.RetrieveWithIterator(); foreach (var item in vendorIterator) { Console.WriteLine(item); } var actual = vendorIterator.ToList(); //Assert CollectionAssert.AreEqual(expected, actual.ToList()); }
public void RetrieveAllVendors() { var repo = new VendorRepository(); var expected = new List <Vendor>() { new Vendor { CompanyName = "Evozon", Email = "[email protected]:=", VendorId = 1 }, new Vendor() { CompanyName = "Vision", Email = "[email protected]:=", VendorId = 3 } }; var vendorList = repo.RetrieveAll(); //var customList = from v in vendorList // where v.CompanyName.Contains("on") // orderby v.VendorId // select v; //customList = (from v in vendorList // where v.VendorId == 1 // select v).ToList(); //var customList = vendorList.Where(FilterVendor) // .OrderBy(OrderVendorById); var customList = vendorList.Where(v => v.CompanyName.Contains("on")) .OrderBy(v => v.VendorId); CollectionAssert.AreEqual(customList.ToList(), expected); }
public void RetrieveVendor() { //arrange var repo = new VendorRepository(); var vendor = new Vendor() { CompanyName = "Endava", Email = "*****@*****.**", VendorId = 1 }; var vendor1 = new Vendor() { CompanyName = "NTT", Email = "*****@*****.**", VendorId = 2 }; var expected = new List <Vendor>(); expected.Add(vendor); expected.Add(vendor1); //act var act = repo.Retrieve(); //assert CollectionAssert.AreEqual(expected, act.ToList()); }
public void RetrieveExistingVendorWithAddress() { //Arrange var vendorRepository = new VendorRepository(); var expected = new Vendor(5) { CompanyName = "Vendor Company", EmailAddress = "*****@*****.**", AddressList = new List <Address>() { new Address() { AddressType = 2, StreetLine1 = "Vendorville", StreetLine2 = "", City = "Manhattan", State = "New York", Country = "USA", PostalCode = "NYC 123" }, new Address() { AddressType = 2, StreetLine1 = "SupplyLand", StreetLine2 = "", City = "Rajneesh", State = "Oregon", Country = "OGN", PostalCode = "OGN 456" } } }; //Act var actual = vendorRepository.Retrieve(5); //Assert Assert.AreEqual(expected.CompanyName, actual.CompanyName); Assert.AreEqual(expected.EmailAddress, actual.EmailAddress); for (int i = 0; i < 2; i++) { Assert.AreEqual(expected.AddressList[i].AddressType, actual.AddressList[i].AddressType); Assert.AreEqual(expected.AddressList[i].StreetLine1, actual.AddressList[i].StreetLine1); Assert.AreEqual(expected.AddressList[i].StreetLine2, actual.AddressList[i].StreetLine2); Assert.AreEqual(expected.AddressList[i].City, actual.AddressList[i].City); Assert.AreEqual(expected.AddressList[i].State, actual.AddressList[i].State); Assert.AreEqual(expected.AddressList[i].Country, actual.AddressList[i].Country); Assert.AreEqual(expected.AddressList[i].PostalCode, actual.AddressList[i].PostalCode); } }
public void RetrieveIterator() { var repository = new VendorRepository(); var expected = new List <Vendor>(); var vendor = new Vendor() { CompanyName = "Endava", Email = "*****@*****.**", VendorId = 1 }; var vendor1 = new Vendor() { CompanyName = "NTT", Email = "*****@*****.**", VendorId = 2 }; expected.Add(vendor); expected.Add(vendor1); var actual = new List <Vendor>(); var vendorIteration = repository.RetrieveWithIterator(); foreach (var item in vendorIteration) { Console.WriteLine(item); actual.Add(item); } CollectionAssert.AreEqual(expected, actual); }
public void RetrieveWithIteratorTest() { var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 1, CompanyName = "ABC Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "Antisom", Email = "*****@*****.**" } }; var vendorIterator = repository.RetrieveWithIterator(); foreach (var item in vendorIterator) { Console.WriteLine(item); } var actual = vendorIterator.ToList(); CollectionAssert.AreEqual(expected, actual); }
public void RetrieveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>(); expected.Add(new Vendor() { VendorId = 6, CompanyName = "Toy Blocks Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 7, CompanyName = "Home Toys Inc", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 8, CompanyName = "Car Toys", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 9, CompanyName = "Toys for Fun", Email = "*****@*****.**" }); var vendors = repository.RetrieveAll(); var vendorQuery = from v in vendors where v.CompanyName.Contains("Toy") orderby v.CompanyName select v; var vendorQuery2 = vendors.Where(v => v.CompanyName.Contains("Toy")).OrderBy(o => o.CompanyName); CollectionAssert.AreEqual(expected, vendorQuery2.ToList()); }
public void RetrieveWithIteratorTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 1, CompanyName = "Technossus", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 2, CompanyName = "Infosys", Email = "*****@*****.**" } } }; //Act var vendorIterator = repository.RetrieveWithIterator(); foreach (var item in vendorIterator) { Console.WriteLine(item); } var actual = vendorIterator.ToList(); //Assert CollectionAssert.AreEqual(expected, actual); }
public void TestGetVendorAddressesReturnsExpectedResults3() { #region Arrange new FakeVendors(5, VendorRepository); var vendorAddresses = new List <VendorAddress>(); for (int i = 0; i < 5; i++) { vendorAddresses.Add(CreateValidEntities.VendorAddress(i + 1)); if (i < 3) { vendorAddresses[i].Vendor = VendorRepository.GetNullableById("1"); } else { vendorAddresses[i].Vendor = VendorRepository.GetNullableById((i + 1).ToString()); } } new FakeVendorAddresses(0, VendorAddressRepository, vendorAddresses, false); #endregion Arrange #region Act var result = Controller.GetVendorAddresses("5") .AssertResultIs <JsonNetResult>(); #endregion Act #region Assert Assert.IsNotNull(result); Assert.AreEqual("[{\"TypeCode\":\"tc5\",\"Name\":\"(tc5) Line15, City5, XX 12345, AA\"}]", result.JsonResultString); #endregion Assert }
public void RetrieveWithIteratorTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 1, CompanyName = "ACB" }, new Vendor() { VendorId = 2, CompanyName = "ZXC" } }; //actual var vendorIterartor = repository.RetrieveWithIterator(); foreach (var item in vendorIterartor) { Console.WriteLine(item); } var actual = vendorIterartor.ToList(); //assert CollectionAssert.AreEqual(expected, actual); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { List <ValidationResult> errors = new List <ValidationResult>(); CustomerRepository cdb = new CustomerRepository(); EmployeeRepository edb = new EmployeeRepository(); VendorRepository vdb = new VendorRepository(); //check if the same login id is available in employee, customer and vendor tables if (cdb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null) { errors.Add(new ValidationResult($"User exists already.", new List <string> { nameof(LoginID) })); } if (edb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null) { errors.Add(new ValidationResult($"User exists already.", new List <string> { nameof(LoginID) })); } if (vdb.GetAll().Where(x => x.LoginID == LoginID).FirstOrDefault() != null) { errors.Add(new ValidationResult($"User exists already.", new List <string> { nameof(LoginID) })); } return(errors); }
public Vendor SingleVendor(int BusinessEntityID) { var repo = new VendorRepository(ConnectionString); _vendor = repo.GetVendor(BusinessEntityID); return(_vendor); }
public IEnumerable <Vendor> Build() { var repo = new VendorRepository(ConnectionString); var vendors = repo.GetVendors(); return(vendors); }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 1, CompanyName = "ABC Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 2, CompanyName = "BABC Corp", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("ABC") // select v; var vendorQuery = vendors.Where(FilterCompanies) .OrderBy(OrderCompanies); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
// load the form private void NewRfp_Load(object sender, EventArgs e) { foreach (Vendor vendor in VendorRepository.RetrieveAll()) { this.chkVendors.Items.Add(vendor); } }
public void RetrieveAllTest() { //Arrange var repository = new VendorRepository(); var expected = new List <Vendor>() { new Vendor() { VendorId = 9, CompanyName = "JKL Toy Corp", Email = "*****@*****.**" }, new Vendor() { VendorId = 7, CompanyName = "TYU Toy Corp", Email = "*****@*****.**" } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Toy") // orderby v.CompanyName // select v; var vendorQuery = vendors .Where(v => v.CompanyName.Contains("Toy")) .OrderBy(v => v.CompanyName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveAllTest() { var repository = new VendorRepository(); var expected = new List <Vendor>() { { new Vendor() { VendorId = 1, CompanyName = "Tech Technossus", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 2, CompanyName = "Tech Infosys", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 3, CompanyName = "Tech LiveDeftsoft", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 4, CompanyName = "Tech TCS", Email = "*****@*****.**" } } }; //Act var vendors = repository.RetrieveAll(); //var vendorQuery = from v in vendors // where v.CompanyName.Contains("Tech") // orderby v.CompanyName // select v; var vendorQuery = vendors.Where(FilterCompanies) .OrderBy(OrderCompaniesByName); //Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void SendEmailTestAdd() { // Example with a generic list of vendors //Arrange var vendorRepository = new VendorRepository(); var vendorsCollection = vendorRepository.Retrieve(); //syntax error because return parameter is IEnumerable and not ICollection // IEnumerable is read only(immutable). Can still cast return to tolist or toarray etc. //vendorsCollection.Add(new Vendor() // { VendorId = 7, CompanyName = "EFG Ltd", Email = "*****@*****.**" }); var expected = new List <string>() { "Message sent: Important message for: ABC Corp", "Message sent: Important message for: XYZ Inc" }; var vendors = vendorsCollection.ToList(); Console.WriteLine(vendors.Count); //Act var actual = Vendor.SendEmail(vendors, "Test Message"); //Assert CollectionAssert.AreEqual(expected, actual); }
public void RetrieveAllTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor> { { new Vendor() { VendorId = 3, CompanyName = "Berni Cat Co", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 4, CompanyName = "Cat Charlie Inc", Email = "*****@*****.**" } }, { new Vendor() { VendorId = 9, CompanyName = "Hogwarts Magic Cat Co", Email = "*****@*****.**" } }, }; // Act var vendors = repository.RetrieveAll(); // var vendorQuery = from v in vendors // where v.CompanyName.Contains("Cat") // select v; var vendorQuery = vendors.Where(v => v.CompanyName.Contains("Cat")) .OrderBy(v => v.CompanyName); // Assert CollectionAssert.AreEqual(expected, vendorQuery.ToList()); }
public void RetrieveWithIteratorTest() { // Arrange var repository = new VendorRepository(); var expected = new List <Vendor>(); expected.Add(new Vendor() { VendorId = 1, CompanyName = "ABC", Email = "*****@*****.**" }); expected.Add(new Vendor() { VendorId = 2, CompanyName = "Fake Doors", Email = "*****@*****.**" }); // Act var vendorIterator = repository.RetrieveWithIterator(); foreach (var vendor in vendorIterator) { Console.WriteLine(vendor); } var actual = vendorIterator.ToList(); // Assert CollectionAssert.AreEqual(expected, actual); }
public void TestBusinessTypeCodeWithTooLongValueDoesNotSave() { Vendor vendor = null; try { #region Arrange vendor = GetValid(9); vendor.BusinessTypeCode = "x".RepeatTimes((2 + 1)); #endregion Arrange #region Act VendorRepository.DbContext.BeginTransaction(); VendorRepository.EnsurePersistent(vendor); VendorRepository.DbContext.CommitTransaction(); #endregion Act } catch (Exception) { Assert.IsNotNull(vendor); Assert.AreEqual(2 + 1, vendor.BusinessTypeCode.Length); var results = vendor.ValidationResults().AsMessageList(); results.AssertErrorsAre(string.Format("The field {0} must be a string with a maximum length of {1}.", "BusinessTypeCode", "2")); //Assert.IsTrue(vendor.IsTransient()); Assert.IsFalse(vendor.IsValid()); throw; } }
public void TestNameWithSpacesOnlyDoesNotSave() { Vendor vendor = null; try { #region Arrange vendor = GetValid(9); vendor.Name = " "; #endregion Arrange #region Act VendorRepository.DbContext.BeginTransaction(); VendorRepository.EnsurePersistent(vendor); VendorRepository.DbContext.CommitTransaction(); #endregion Act } catch (Exception) { Assert.IsNotNull(vendor); var results = vendor.ValidationResults().AsMessageList(); results.AssertErrorsAre(string.Format("The {0} field is required.", "Name")); //Assert.IsTrue(vendor.IsTransient()); Assert.IsFalse(vendor.IsValid()); throw; } }
public ContactService(RequestContext c, AddressRepository addresses, PriceGroupRepository pricegroups, MailingListRepository mailingLists, VendorRepository vendors, ManufacturerRepository manufacturers, AffiliateRepository affiliates, AffiliateReferralRepository affiliateReferrals) { context = c; Addresses = addresses; PriceGroups = pricegroups; this.MailingLists = mailingLists; this.Vendors = vendors; this.Manufacturers = manufacturers; this.Affiliates = affiliates; this.AffiliateReferrals = affiliateReferrals; }
public void Initialize(string filename) { IDatabaseFactory databaseFactory = new DatabaseFactory(); IUnitOfWork unitOfWork = new UnitOfWork(databaseFactory); IAccountRepository accountRepository = new AccountRepository(databaseFactory); ITransactionRepository transactionRepository = new TransactionRepository(databaseFactory); ICategoryRepository categoryRepository = new CategoryRepository(databaseFactory); IVendorRepository vendorRepository = new VendorRepository(databaseFactory); ICategoryGroupRepository categoryGroupRepository = new CategoryGroupRepository(databaseFactory); IBillRepository billRepository = new BillRepository(databaseFactory); IBillTransactionRepository billTransactionRepository = new BillTransactionRepository(databaseFactory); IBillGroupRepository billGroupRepository = new BillGroupRepository(databaseFactory); IBudgetCategoryRepository budgetCategoryRepository = new BudgetCategoryRepository(databaseFactory); IAccountGroupRepository accountGroupRepository = new AccountGroupRepository(databaseFactory); IImportDescriptionVendorMapRepository importDescriptionVendorMapRepository = new ImportDescriptionVendorMapRepository(databaseFactory); IAccountService accountService = new AccountService(unitOfWork, accountRepository, transactionRepository, categoryRepository, vendorRepository, billRepository, billTransactionRepository, billGroupRepository, categoryGroupRepository, budgetCategoryRepository, importDescriptionVendorMapRepository); TransactionImporter importer = new TransactionImporter(unitOfWork, accountService, accountRepository, transactionRepository, vendorRepository, categoryGroupRepository, accountGroupRepository, importDescriptionVendorMapRepository); importer.Import(filename); }