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