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);
}
