/// <summary> /// DeleteVolunteerContext - Will do a soft delete (make inactive) by VolID /// </summary> /// <param name="_cVolunteer"></param> public void DeleteVendorContext(sp_Vendor_DM _cVendor) { using (VolTeerEntities context = new VolTeerEntities()) { var VendorToRemove = (from n in context.tblVendors where n.VendorID == _cVendor.VendorID select n).FirstOrDefault(); context.tblVendors.Remove(VendorToRemove); context.SaveChanges(); } }
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 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"); } }
/// <summary> /// InsertVolunteerContext - Will insert a record into Volunteer table via SProc /// </summary> /// <param name="_cVolunteer"></param> public sp_Vendor_DM InsertVendorContext(ref sp_Vendor_DM _cVendor) { using (VolTeerEntities context = new VolTeerEntities()) { var cVendor = new tblVendor { ActiveFlg = _cVendor.ActiveFlg, VendorID = _cVendor.VendorID, VendorName = _cVendor.VendorName }; context.tblVendors.Add(cVendor); context.SaveChanges(); return _cVendor; } }
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 UpdateVolunteerContext(sp_Vendor_DM _cVendor) { dal.UpdateVolunteerContext(_cVendor); }
public sp_Vendor_DM InsertVendorContext(ref sp_Vendor_DM _cVendor) { return dal.InsertVendorContext(ref _cVendor); }
public void DeleteVendorContext(sp_Vendor_DM _cVendor) { dal.DeleteVendorContext(_cVendor); }
/// <summary> /// UpdateSampleAddressContext - Will update a given Volunteer record by VolID /// </summary> /// <param name="_cVolunteer"></param> public void UpdateVolunteerContext(sp_Vendor_DM _cVendor) { using (VolTeerEntities context = new VolTeerEntities()) { var cVendor = context.tblVendors.Find(_cVendor.VendorID); if (cVendor != null) { cVendor.VendorName = _cVendor.VendorName; cVendor.VendorID = _cVendor.VendorID; cVendor.ActiveFlg = _cVendor.ActiveFlg; context.SaveChanges(); } } }