public void TestContactUpdate()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "Vendor.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
string vendorID = row["VendorID"].ToString();
string updateVendorName = "TestVendorName";;
sp_Vendor_DM data = new sp_Vendor_DM();
data.VendorID = new Guid(vendorID);
data.VendorName = updateVendorName;
sp_Vendor_BLL vendor = new sp_Vendor_BLL();
vendor.UpdateVolunteerContext(data);
data = vendor.ListVendors(new Guid(vendorID));
Assert.AreEqual(updateVendorName, data.VendorName, "Vendor Name Not Set As Expected");
}
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
//Log the user in
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false);
// Create Volunteer Record
RadTextBox userNameTextBox = (RadTextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName");
MembershipUser user = Membership.GetUser(userNameTextBox.Text);
sp_Vendor_BLL bll = new sp_Vendor_BLL();
sp_Vendor_DM venddm = new sp_Vendor_DM();
venddm.ActiveFlg = true;
venddm.VendorName = "test";
venddm.VendorID = (Guid)user.ProviderUserKey;
venddm = bll.InsertVendorContext(ref venddm);
cMail.SendMessage("*****@*****.**", (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Email") as RadTextBox).Text.Trim(), "VolTeer Registration", "Please click link to confirm");
string continueUrl = "~/";
Response.Redirect(continueUrl);
}
public void TestVendorAddrCreate()
{
//create a vendor
sp_Vendor_DM data = new sp_Vendor_DM();
data.VendorID = new Guid();
string vendorName = "My Name";
data.VendorName = vendorName;
data.ActiveFlg = true;
sp_Vendor_BLL vendor = new sp_Vendor_BLL();
vendor.InsertVendorContext(ref data);
//Insert Vendor Addr
sp_VendorAddr_DM data1 = new sp_VendorAddr_DM();
data1.VendorID = data.VendorID;
data1.AddrID = 1;
sp_VendorAddr_BLL vendoraddr = new sp_VendorAddr_BLL();
vendoraddr.InsertAddressContext(data1);
//Read Vendor Add
var newdata = vendoraddr.ListAddresses(data1.VendorID);
Assert.AreEqual(newdata.VendorID, data.VendorID, "VendorID Not Set As Expected");
Assert.AreEqual(newdata.AddrID, 1, "AddrID Not Set As Expected");
}
public void TestVendorRead()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "Vendor.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
string vendorID = row["VendorID"].ToString();
sp_Vendor_BLL vendor = new sp_Vendor_BLL();
sp_Vendor_DM data = vendor.ListVendors(new Guid(vendorID));
Assert.AreEqual(row["VendorName"].ToString(), data.VendorName, "Vendor Name Not Set As Expected");
}
}
public void TestVendorCreate()
{
sp_Vendor_DM data = new sp_Vendor_DM();
data.VendorID = new Guid();
string vendorName = "My Name";
data.VendorName= vendorName;
data.ActiveFlg = true;
sp_Vendor_BLL vendor = new sp_Vendor_BLL();
vendor.InsertVendorContext(ref data);
Assert.AreEqual(vendorName, data.VendorName, "Vendor Name Not Set As Expected");
Assert.AreEqual(true, data.ActiveFlg, "Active Flag Not Set As Expected");
}
public void TestVendorReadAll()
{
//Pull our data from the excel file
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "Vendor.xlsx"));
//Pull our data directly from the DB
var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblVendor]");
//Pull our data from the DB through the BLL
sp_Vendor_BLL vendor = new sp_Vendor_BLL();
var allVendors = vendor.ListVendors();
//Test the data from the BLL
Assert.AreEqual(numRows, allVendors.Count);
}
