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