public void Get_Returns_500_When_Exception()
{
//-------------------------------------
//Arrange
//-------------------------------------
Mock <IVendorService> mockService = new Mock <IVendorService>();
mockService.Setup(m => m.GetVendor(
It.IsAny <int>()
)).Throws(new Exception("error"));
IVendorService vendorService = mockService.Object;
VendorsController controller = new VendorsController(vendorService);
//-------------------------------------
//Act
//-------------------------------------
ActionResult actionResult = controller.Get(int.MaxValue);
//-------------------------------------
//Asserts
//-------------------------------------
Assert.NotNull(actionResult);
var result = Assert.IsType <ObjectResult>(actionResult);
Assert.Equal(500, result.StatusCode);
}
public VendorsControllerShould()
{
_loggerMock = new Mock <ILogger>();
_vendorsQueryMock = new Mock <IVendorsQuery>();
_addressQueryMock = new Mock <IAddressesQuery>();
_vendorServicesQueryMock = new Mock <IVendorServicesQuery>();
_eventsQueryMock = new Mock <IEventQuery>();
_guestQueryMock = new Mock <IGuestQuery>();
_user = new ClaimsPrincipal(new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.NameIdentifier, "1")
}));
_sut = new VendorsController(
_vendorsQueryMock.Object,
_addressQueryMock.Object,
_vendorServicesQueryMock.Object,
_eventsQueryMock.Object,
_guestQueryMock.Object,
_loggerMock.Object);
_sut.ControllerContext = new ControllerContext()
{
HttpContext = new DefaultHttpContext()
{
User = _user
}
};
}
protected void btnSelectVendor_Click(object sender, EventArgs e)
{
if (VendorDDL.SelectedIndex == 0)
{
pnlInventory.Visible = false;
pnlVendorResults.Visible = false;
MessageUserControl.ShowInfo("Missing Data", "Select a vendor from the drop down list");
}
else
{
MessageUserControl.TryRun(() =>
{
pnlInventory.Visible = true;
pnlVendorResults.Visible = true;
txtComments.Text = "Comments";
// Vendors Controller to get orders
VendorsController sysmgr = new VendorsController();
OrderDetailsController controller = new OrderDetailsController();
int vendorId = int.Parse(VendorDDL.SelectedValue);
var info = sysmgr.Purchasing_Vendor_Get(vendorId);
lblVendorName.Text = info.Name;
lblVendorContact.Text = info.Contact;
lblPhone.Text = info.Phone;
//txtComments.Text = info.Orders.Comment;
// Calculate Total
CalculateTotal(controller, vendorId);
var data = controller.Get_Active_Order(int.Parse(VendorDDL.SelectedValue));
OrderDetailsGridView.DataSource = data;
OrderDetailsGridView.DataBind();
}, "Vendors Selection", "Active Order Retrieved");
}
}
public void Get_Returns_NotFound_When_Vendor_NotFound()
{
//-------------------------------------
//Arrange
//-------------------------------------
Vendor vendor = null;
Mock <IVendorService> mockService = new Mock <IVendorService>();
mockService.Setup(m => m.GetVendor(
It.IsAny <int>()
)).Returns(vendor);
IVendorService vendorService = mockService.Object;
VendorsController controller = new VendorsController(vendorService);
//-------------------------------------
//Act
//-------------------------------------
ActionResult actionResult = controller.Get(int.MaxValue);
//-------------------------------------
//Asserts
//-------------------------------------
Assert.NotNull(actionResult);
var result = Assert.IsType <NotFoundResult>(actionResult);
}
protected void VendorFetch_Click(object sender, EventArgs e)
{
if (VendorDDL.SelectedValue == null)
{
MessageUserControl.ShowInfo("Missing Data", "Select a PO from the drop down list");
}
else
{
MessageUserControl.TryRun(() =>
{
UnorderedItemsListView.Items.Clear();
UnOrderedItemController sysmanager = new UnOrderedItemController();
sysmanager.Remove_UnorderedItems();
UnorderedItemsListView.DataBind();
ReceivingPanel.Visible = true;
VendorsController sysmgr = new VendorsController();
var info = sysmgr.Vendor_Get(int.Parse(VendorDDL.SelectedValue));
VendorName.Text = info.VendorName;
AddressAndCity.Text = info.AddressandCity;
Contact.Text = info.ContactName;
PhoneNumber.Text = info.Phone;
ReasonCommentReasonMessage.Text = "";
// also need to make sure if quantity oustanding if = 0 make it not show outstanding for that specific row
}, "Orders Search", "Order selected successful");
}
}
static void ActnVendor()
{
//Returns all
VendorsController VendorCtrl = new VendorsController(@"STUDENT50\SQLEXPRESS", "prssql");
IEnumerable <Vendor> vendor = VendorCtrl.List();
foreach (Vendor Vendor1 in vendor)
{
Console.WriteLine($"{Vendor1.Code} {Vendor1.Name} {Vendor1.Address}");
}
Vendor Amzn = VendorCtrl.Get(1);
if (Amzn == null)
{
Console.WriteLine("Vendor not found");
}
else
{
Console.WriteLine($"{Amzn.Code} {Amzn.Name} {Amzn.Address}");
}
Amzn = VendorCtrl.Get(999);
if (Amzn == null)
{
Console.WriteLine("User not found");
}
else
{
Console.WriteLine($"{Amzn.Code} {Amzn.Name} {Amzn.Address}");
}
Vendor newVendor = new Vendor()
{
Code = "Walm",
Address = "564 Walmart way",
Name = "Walmart",
City = "Walmartville",
State = "GA",
Zip = "98123",
Email = "*****@*****.**",
Phone = "987-456-1203",
Active = true,
IsPreapproved = true
};
//bool success = VendorCtrl.Create(newVendor);
Vendor vendorWal = VendorCtrl.Get(5);
vendorWal.Code = "WAL";
//bool success = VendorCtrl.Change(vendorWal);
bool success = VendorCtrl.Remove(vendorWal);
VendorCtrl.CloseConnection();
}
public void ReturnViewForEditWithoutVendor()
{
_mockVendorRepo.Setup(x => x.GetById(It.IsAny <int>())).Returns((Vendor)null);
_sut = new VendorsController(_mockVendorRepo.Object);
IActionResult redirectToActionResult = _sut.EditVendor(1);
Assert.IsType <RedirectToActionResult>(redirectToActionResult);
}
public void ReturnViewForIndexWithoutVendors()
{
_mockVendorRepo.Setup(x => x.GetAll()).Returns(new List <Vendor>());
_sut = new VendorsController(_mockVendorRepo.Object);
IActionResult result = _sut.Index();
Assert.IsType <ViewResult>(result);
}
public void Index()
{
// Arrange
VendorsController controller = new VendorsController();
// Act
ViewResult result = controller.Index() as ViewResult;
// Assert
Assert.AreEqual("VENDORS", result.ViewBag.Message);
}
public void GetSingleVendorTest()
{
// Arrange
VendorsController VendorController = new VendorsController();
// Act
ViewResult result = VendorController.Edit(1) as ViewResult;
// Assert
Assert.IsNotNull(result);
}
protected void OnEmailClick(object sender, EventArgs e)
{
//send email summary to vendor
var objBanners = new BannerController();
var objBanner = objBanners.GetBanner(BannerId);
if (objBanner != null)
{
var objVendors = new VendorsController();
var objVendor = objVendors.GetVendor(objBanner.VendorId, PortalId);
if (objVendor != null)
{
if (!Null.IsNull(objVendor.Email))
{
var Custom = new ArrayList();
Custom.Add(objBanner.BannerName);
Custom.Add(objBanner.Description);
Custom.Add(objBanner.ImageFile);
Custom.Add(objBanner.CPM.ToString("#0.#####"));
Custom.Add(objBanner.Impressions.ToString());
Custom.Add(objBanner.StartDate.ToShortDateString());
Custom.Add(objBanner.EndDate.ToShortDateString());
Custom.Add(objBanner.Views.ToString());
Custom.Add(objBanner.ClickThroughs.ToString());
var errorMsg = Mail.SendMail(PortalSettings.Email,
objVendor.Email,
"",
Localization.GetSystemMessage(PortalSettings, "EMAIL_BANNER_NOTIFICATION_SUBJECT", Localization.GlobalResourceFile, Custom),
Localization.GetSystemMessage(PortalSettings, "EMAIL_BANNER_NOTIFICATION_BODY", Localization.GlobalResourceFile, Custom),
"",
"",
"",
"",
"",
"");
string strMessage;
if (String.IsNullOrEmpty(errorMsg))
{
strMessage = Localization.GetString("EmailSuccess", LocalResourceFile);
DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, strMessage, ModuleMessage.ModuleMessageType.GreenSuccess);
}
else
{
strMessage = Localization.GetString("EmailFailure", LocalResourceFile);
strMessage = string.Format(strMessage, errorMsg);
DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, strMessage, ModuleMessage.ModuleMessageType.RedError);
}
}
}
}
}
public void NotSaveToDatabaseWithModelError()
{
_mockVendorRepo.Setup(x => x.GetById(It.IsAny <int>())).Returns(_vendor1);
var model = new VendorEditViewModel();
_sut = new VendorsController(_mockVendorRepo.Object);
_sut.ModelState.AddModelError("x", "Test Error");
_sut.EditVendor(1, model);
_mockVendorRepo.Verify(x => x.Commit(), Times.Never);
}
/// -----------------------------------------------------------------------------
/// <summary>
/// cmdDelete_Click runs when the Delete button is clicked.
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/17/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected void OnDeleteClick(object sender, EventArgs e)
{
try
{
if (VendorID != -1)
{
var objVendors = new VendorsController();
objVendors.DeleteVendor(VendorID);
}
Response.Redirect(Globals.NavigateURL());
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public void CommitToDatabaseWithValidVendorEdit()
{
_mockVendorRepo.Setup(x => x.GetById(It.IsAny <int>())).Returns(_vendor2);
var model = new VendorEditViewModel()
{
VendorName = "New Name",
VendorNumber = 201,
Description = "New Description",
Status = VendorStatus.NonTaxable
};
_sut = new VendorsController(_mockVendorRepo.Object);
_sut.EditVendor(1, model);
_mockVendorRepo.Verify(x => x.Commit(), Times.Once);
}
void cmdDeleteUnAuthorized_Click(object sender, EventArgs e)
{
try
{
var objVendors = new VendorsController();
if (Globals.IsHostTab(PortalSettings.ActiveTab.TabID))
{
objVendors.DeleteVendors();
}
else
{
objVendors.DeleteVendors(PortalId);
}
Response.Redirect(Globals.NavigateURL(), true);
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
/// -----------------------------------------------------------------------------
/// <summary>
/// cmdSend_Click runs when the Send Notification Button is clicked
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/21/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected void OnSendClick(object sender, EventArgs e)
{
var objVendors = new VendorsController();
var objVendor = objVendors.GetVendor(VendorId, PortalId);
if (objVendor != null)
{
if (!Null.IsNull(objVendor.Email))
{
var custom = new ArrayList
{
objVendor.VendorName,
Globals.GetPortalDomainName(PortalSettings.PortalAlias.HTTPAlias, Request, true) + "/" + Globals.glbDefaultPage + "?AffiliateId=" + AffiliateId
};
var errorMsg = Mail.SendMail(PortalSettings.Email,
objVendor.Email,
"",
Localization.GetSystemMessage(PortalSettings, "EMAIL_AFFILIATE_NOTIFICATION_SUBJECT"),
Localization.GetSystemMessage(PortalSettings, "EMAIL_AFFILIATE_NOTIFICATION_BODY", Localization.GlobalResourceFile, custom),
"",
"",
"",
"",
"",
"");
string strMessage;
if (String.IsNullOrEmpty(errorMsg))
{
strMessage = Localization.GetString("NotificationSuccess", LocalResourceFile);
DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, strMessage, ModuleMessage.ModuleMessageType.GreenSuccess);
}
else
{
strMessage = Localization.GetString("NotificationFailure", LocalResourceFile);
strMessage = string.Format(strMessage, errorMsg);
DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, strMessage, ModuleMessage.ModuleMessageType.RedError);
}
}
}
}
public void Get_Returns_Ok_When_All_Valid()
{
//Arrange
int vendorId = 23;
//-------------------------------------
var vendor = new Vendor
{
VendorID = vendorId,
VendorName = "hehehe",
VendorPhone = "2223334455"
};
Mock <IVendorService> mockService = new Mock <IVendorService>();
mockService.Setup(m => m.GetVendor(
It.IsAny <int>()
)).Returns(vendor);
IVendorService vendorService = mockService.Object;
VendorsController controller = new VendorsController(vendorService);
//-------------------------------------
//Act
//-------------------------------------
ActionResult actionResult = controller.Get(int.MaxValue);
//-------------------------------------
//Asserts
//-------------------------------------
Assert.NotNull(actionResult);
var result = Assert.IsType <OkObjectResult>(actionResult);
Vendor vendorResult = result.Value as Vendor;
Assert.NotNull(vendorResult);
Assert.Equal(vendorId, vendor.VendorID);
}
public void GetAll_Returns_500_When_Exception()
{
//Arrange
Mock <IVendorService> mockService = new Mock <IVendorService>();
mockService.Setup(m => m.GetVendorList())
.Throws(new Exception("error"));
VendorsController controller = new VendorsController(mockService.Object);
//Act
ActionResult actionResult = controller.Get();
//Asserts
Assert.NotNull(actionResult);
var result = Assert.IsType <ObjectResult>(actionResult);
Assert.Equal(500, result.StatusCode);
}
public void GetAll_Returns_Ok_When_All_Valid()
{
//Arrange
var vendorList = new List <Vendor> {
new Vendor {
VendorID = 1,
VendorName = "hahaha",
VendorPhone = "9998887766"
},
new Vendor {
VendorID = 2,
VendorName = "lalala",
VendorPhone = "1112223344"
},
};
Mock <IVendorService> mockService = new Mock <IVendorService>();
mockService.Setup(m => m.GetVendorList()).Returns(vendorList);
IVendorService vendorService = mockService.Object;
VendorsController controller = new VendorsController(vendorService);
//Act
ActionResult actionResult = controller.Get();
//Asserts
Assert.NotNull(actionResult);
var result = Assert.IsType <OkObjectResult>(actionResult);
List <Vendor> list = result.Value as List <Vendor>;
Assert.Equal(2, list.Count);
}
static void Main(string[] args)
{
UsersController UserCtrl = new SqlLibrary.UsersController(@"STUDENT12\SQLEXPRESS", "PRSDatabase");
// IEnumerable<User> users = UserCtrl.List();
// foreach (User user1 in users) {
// Console.WriteLine($"{user1.FirstName} {user1.LastName}");
//}
//User user = UserCtrl.Get(5);
//if(user == null) {
// Console.WriteLine("User not found");
//} else {
// Console.WriteLine($"{user.FirstName} {user.LastName}");
//}
//user = UserCtrl.Get(999);
//if (user == null) {
// Console.WriteLine("User not found");
//} else {
// Console.WriteLine($"{user.FirstName} {user.LastName}");
//}
//User newUser = new User();
//newUser.Username = "******"; ;
//newUser.Password = "******";
//newUser.FirstName = "Last";
//newUser.LastName = "first";
//newUser.Phone = "513-555-0000";
//newUser.Email = "newuser@gmail";
//newUser.IsReviewer = true;
//newUser.IsAdmin = true;
//newUser.Active = true;
//bool success = UserCtrl.Create(newUser);
//User user = UserCtrl.Get(5);
//user.FirstName = "Harvy";
//bool success = UserCtrl.Change(user);
//user = UserCtrl.Get(10);
//success = UserCtrl.Remove(user);
//UserCtrl.CloseConection();
VendorsController vendorctrl = new VendorsController(@"STUDENT12\SQLEXPRESS", "PRSDatabase");
IEnumerable <Vendor> Vendors = vendorctrl.List();
foreach (Vendor vendors in Vendors)
{
Console.WriteLine($"{vendors.Code} {vendors.Name}");
}
//Vendor newVendor = new Vendor();
//newVendor.Code = "EGG"; //Must be a unique value
//newVendor.Name = "New Egg";
//newVendor.Address = "123 Main Street";
//newVendor.City = "Cincinnati";
//newVendor.State = "OH";
//newVendor.Zip = "45002";
//newVendor.Phone = "nani";
//newVendor.Email = "nano";
//newVendor.IsPreApproved = true;
//bool success = vendorctrl.Create(newVendor);
//Console.WriteLine($"New vendor successfully added = {success}");
//Vendor vendor = vendorctrl.Get(2);
//vendor.Code = "TAR";
//success = vendorctrl.Change(vendor);
Vendor vendordlt = vendorctrl.Get(12);
bool deleted = vendorctrl.Remove(vendordlt);
Console.WriteLine($"Vendor Successfully removed = {deleted}");
}
/// -----------------------------------------------------------------------------
/// <summary>
/// Page_Load runs when the control is loaded
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/17/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
cmdCancel.Click += OnCancelClick;
cmdDelete.Click += OnDeleteClick;
cmdUpdate.Click += OnUpdateClick;
try
{
var blnBanner = false;
var blnSignup = false;
if ((Request.QueryString["VendorID"] != null))
{
VendorID = Int32.Parse(Request.QueryString["VendorID"]);
}
if (Request.QueryString["ctl"] != null && VendorID == -1)
{
blnSignup = true;
}
if (Request.QueryString["banner"] != null)
{
blnBanner = true;
}
if (Page.IsPostBack == false)
{
ctlLogo.FileFilter = Globals.glbImageFileTypes;
addresssVendor.ModuleId = ModuleId;
addresssVendor.StartTabIndex = 4;
var objVendors = new VendorsController();
if (VendorID != -1)
{
VendorInfo objVendor;
if (Globals.IsHostTab(PortalSettings.ActiveTab.TabID) && UserInfo.IsSuperUser)
{
//Get Host Vendor
objVendor = objVendors.GetVendor(VendorID, Null.NullInteger);
}
else
{
//Get Portal Vendor
objVendor = objVendors.GetVendor(VendorID, PortalId);
}
if (objVendor != null)
{
txtVendorName.Text = objVendor.VendorName;
txtFirstName.Text = objVendor.FirstName;
txtLastName.Text = objVendor.LastName;
ctlLogo.Url = objVendor.LogoFile;
addresssVendor.Unit = objVendor.Unit;
addresssVendor.Street = objVendor.Street;
addresssVendor.City = objVendor.City;
addresssVendor.Region = objVendor.Region;
addresssVendor.Country = objVendor.Country;
addresssVendor.Postal = objVendor.PostalCode;
addresssVendor.Telephone = objVendor.Telephone;
addresssVendor.Fax = objVendor.Fax;
addresssVendor.Cell = objVendor.Cell;
txtEmail.Text = objVendor.Email;
txtWebsite.Text = objVendor.Website;
chkAuthorized.Checked = objVendor.Authorized;
txtKeyWords.Text = objVendor.KeyWords;
ctlAudit.CreatedByUser = objVendor.CreatedByUser;
ctlAudit.CreatedDate = objVendor.CreatedDate.ToString();
}
//use dispatch method to load modules
var banners = ControlUtilities.LoadControl <Banners>(this, TemplateSourceDirectory.Remove(0, Globals.ApplicationPath.Length) + "/Banners.ascx");
banners.ID = "/Banners.ascx";
banners.VendorID = VendorID;
banners.ModuleConfiguration = ModuleConfiguration;
divBanners.Controls.Add(banners);
var affiliates = ControlUtilities.LoadControl <Affiliates>(this, TemplateSourceDirectory.Remove(0, Globals.ApplicationPath.Length) + "/Affiliates.ascx");
affiliates.ID = "/Affiliates.ascx";
affiliates.VendorID = VendorID;
affiliates.ModuleConfiguration = ModuleConfiguration;
divAffiliates.Controls.Add(affiliates);
}
else
{
chkAuthorized.Checked = true;
ctlAudit.Visible = false;
cmdDelete.Visible = false;
pnlBanners.Visible = false;
pnlAffiliates.Visible = false;
}
if (blnSignup || blnBanner)
{
rowVendor1.Visible = false;
rowVendor2.Visible = false;
pnlVendor.Visible = false;
cmdDelete.Visible = false;
ctlAudit.Visible = false;
if (blnBanner)
{
cmdUpdate.Visible = false;
}
else
{
cmdUpdate.Text = "Signup";
}
}
else
{
TabInfo objTab = TabController.Instance.GetTabByName("Vendors", Globals.IsHostTab(PortalSettings.ActiveTab.TabID) ? Null.NullInteger : PortalId);
if (objTab != null)
{
ViewState["filter"] = Request.QueryString["filter"];
}
}
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
/// -----------------------------------------------------------------------------
/// <summary>
/// cmdUpdate_Click runs when the Update button is clicked.
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/17/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected void OnUpdateClick(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
int portalID;
if (Globals.IsHostTab(PortalSettings.ActiveTab.TabID))
{
portalID = -1;
}
else
{
portalID = PortalId;
}
var objVendors = new VendorsController();
var objVendor = new VendorInfo
{
PortalId = portalID,
VendorId = VendorID,
VendorName = txtVendorName.Text,
Unit = addresssVendor.Unit,
Street = addresssVendor.Street,
City = addresssVendor.City,
Region = addresssVendor.Region,
Country = addresssVendor.Country,
PostalCode = addresssVendor.Postal,
Telephone = addresssVendor.Telephone,
Fax = addresssVendor.Fax,
Cell = addresssVendor.Cell,
Email = txtEmail.Text,
Website = txtWebsite.Text,
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
UserName = UserInfo.UserID.ToString(),
LogoFile = ctlLogo.Url,
KeyWords = txtKeyWords.Text,
Authorized = chkAuthorized.Checked
};
if (VendorID == -1)
{
try
{
VendorID = objVendors.AddVendor(objVendor);
}
catch (Exception exc)
{
//AddModuleMessage("ErrorAddVendor", ModuleMessage.ModuleMessageType.RedError);
Exceptions.ProcessModuleLoadException(this, exc);
return;
}
}
else
{
VendorInfo vendorCheck = objVendors.GetVendor(VendorID, portalID);
if (vendorCheck != null)
{
objVendors.UpdateVendor(objVendor);
}
else
{
Response.Redirect(Globals.NavigateURL());
}
}
if (cmdUpdate.Text == "Signup")
{
var custom = new ArrayList();
custom.Add(DateTime.Now.ToString());
custom.Add(txtVendorName.Text);
custom.Add(txtFirstName.Text);
custom.Add(txtLastName.Text);
custom.Add(addresssVendor.Unit);
custom.Add(addresssVendor.Street);
custom.Add(addresssVendor.City);
custom.Add(addresssVendor.Region);
custom.Add(addresssVendor.Country);
custom.Add(addresssVendor.Postal);
custom.Add(addresssVendor.Telephone);
custom.Add(addresssVendor.Fax);
custom.Add(addresssVendor.Cell);
custom.Add(txtEmail.Text);
custom.Add(txtWebsite.Text);
//send email to Admin
Mail.SendEmail(PortalSettings.Email,
PortalSettings.Email,
Localization.GetSystemMessage(PortalSettings, "EMAIL_VENDOR_REGISTRATION_ADMINISTRATOR_SUBJECT"),
Localization.GetSystemMessage(PortalSettings, "EMAIL_VENDOR_REGISTRATION_ADMINISTRATOR_BODY", Localization.GlobalResourceFile, custom));
//send email to vendor
custom.Clear();
custom.Add(txtFirstName.Text);
custom.Add(txtLastName.Text);
custom.Add(txtVendorName.Text);
Mail.SendEmail(PortalSettings.Email,
txtEmail.Text,
Localization.GetSystemMessage(PortalSettings, "EMAIL_VENDOR_REGISTRATION_SUBJECT"),
Localization.GetSystemMessage(PortalSettings, "EMAIL_VENDOR_REGISTRATION_BODY", Localization.GlobalResourceFile, custom));
ReturnUrl(txtVendorName.Text.Substring(0, 1));
}
else
{
ReturnUrl(Convert.ToString(ViewState["filter"]));
}
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public VendorControllerTests()
{
mockService = new Mock <IVendorService>();
controller = new VendorsController(mockService.Object);
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
//exit without incrementing count if page is indexed by crawler
if (Request.Browser.Crawler)
{
return;
}
try
{
if ((Request.QueryString["vendorid"] != null) && (Request.QueryString["bannerid"] != null))
{
int intVendorId = -1;
if (Regex.IsMatch(Request.QueryString["vendorid"], "^\\d+$"))
{
intVendorId = int.Parse(Request.QueryString["vendorid"]);
}
int intBannerId = -1;
if (Regex.IsMatch(Request.QueryString["bannerid"], "^\\d+$"))
{
intBannerId = int.Parse(Request.QueryString["bannerid"]);
}
int intPortalId = -1;
if ((Request.QueryString["portalid"] != null))
{
if (Regex.IsMatch(Request.QueryString["portalid"], "^\\d+$"))
{
intPortalId = int.Parse(Request.QueryString["portalid"]);
}
}
else
{
intPortalId = Globals.GetPortalSettings().PortalId;
}
if (intBannerId != -1 && intVendorId != -1 && intPortalId != -1)
{
string strURL = "~/" + Globals.glbDefaultPage;
var objBanners = new BannerController();
BannerInfo objBanner = objBanners.GetBanner(intBannerId);
if (objBanner != null)
{
if (objBanners.IsBannerActive(objBanner))
{
if (!Null.IsNull(objBanner.URL))
{
strURL = Globals.LinkClick(objBanner.URL, -1, -1, false);
}
else
{
var objVendors = new VendorsController();
VendorInfo objVendor = objVendors.GetVendor(objBanner.VendorId, intPortalId);
if (objVendor == null)
{
objVendor = objVendors.GetVendor(objBanner.VendorId, Null.NullInteger);
}
if (objVendor != null)
{
if (!String.IsNullOrEmpty(objVendor.Website))
{
strURL = Globals.AddHTTP(objVendor.Website);
}
}
}
objBanners.UpdateBannerClickThrough(intBannerId, intVendorId);
}
}
else if (Request.UrlReferrer != null)
{
strURL = Request.UrlReferrer.ToString();
}
Response.Redirect(strURL, true);
}
}
}
catch (ThreadAbortException)
{
//ignore the abort thread expcetion.
}
catch (Exception exc) //Page failed to load
{
Exceptions.ProcessPageLoadException(exc);
}
}
static void Main(string[] args) {
//opens the connection to SQL via the UsersController constructor
UsersController UserCtrl = new UsersController(@"STUDENT03\SQLEXPRESS", "prssql");
VendorsController VendorCtrl =new VendorsController(@"STUDENT03\SQLEXPRESS", "prssql");
//VENDOR CODE STARTS HERE
//returns the list of all vendors in the Vendor table in prssql database
Console.WriteLine("List of all vendors:");
IEnumerable<Vendor> vendors = VendorCtrl.List();
foreach (Vendor vendor1 in vendors) {
Console.WriteLine($"{vendor1.Code} {vendor1.Name}");
}
//get the vendor with id number in "VendorCtrl.Get(#)
Console.WriteLine("-----------------------------------------------");
Vendor vendor = VendorCtrl.Get(3);
if (vendor == null) {
Console.WriteLine("Vendor not found");
} else {
Console.WriteLine($"Id {vendor.Id} is {vendor.Code} {vendor.Name}");
Console.WriteLine("-----------------------------------------------");
}
//Begin adding a vendor code here
Console.WriteLine("-----------------------------------------------");
//Vendor newVendor = new Vendor("NOVN", "Novan", "4105 Hopson Road", "Morrisville", "NC", "27560", "919-485-8080", "*****@*****.**", true, true);
//add newVendor to the database
//bool vendorAddSuccess = VendorCtrl.Create(newVendor); //commented out so this won't keep adding to the DB
//END adding a vendor code here
//changing/updating the data in the vendor table
vendor = VendorCtrl.Get(6);
vendor.Email = "*****@*****.**";
bool VendorChangeSuccess = VendorCtrl.Change(vendor);
//delete a vendor
//vendor = VendorCtrl.Get(6);
//bool VendorDeleteSuccess = VendorCtrl.Remove(vendor);
//VENDOR CODE ENDS HERE
/////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////
//USER CODE BELOW HERE
//returns the list of all users in the [User] table in prssql database
Console.WriteLine("List of all users:");
IEnumerable<User> users = UserCtrl.List();
foreach (User user1 in users) {
Console.WriteLine($"{user1.Firstname} {user1.Lastname}");
}
//get the user with id number in "UserCtrl.Get(#)
Console.WriteLine("-----------------------------------------------");
User user = UserCtrl.Get(11);
if (user == null) {
Console.WriteLine("User not found");
} else {
Console.WriteLine($"Id {user.Id} is {user.Firstname} {user.Lastname}");
}
//intentionally putting in bad user id to see if it returns User not found
Console.WriteLine("-----------------------------------------------");
//get the user with id number in "UserCtrl.Get(#)
User user2 = UserCtrl.Get(99);
if (user2 == null) {
Console.WriteLine("User not found");
} else {
Console.WriteLine($"Id {user2.Id} is {user2.Firstname} {user2.Lastname}");
}
//CREATE NEW USER//
//User newUser = new User();
//newUser.Username = "******";
//newUser.Password = "******";
//newUser.Firstname = "New";
//newUser.Lastname = "User";
//newUser.Phone = "555-1234";
//newUser.Email = "*****@*****.**";
//newUser.IsReviewer = true;
//newUser.IsAdmin = false;
//newUser.Active = false;
//add new user to the database//
//bool success = UserCtrl.Create(newUser);
//END CREATE NEW USER//
//changing/updating the data in the user table
user = UserCtrl.Get(3);
user.Firstname= "user3";
bool success = UserCtrl.Change(user);
//delete a user
//user = UserCtrl.Get(13);
//success = UserCtrl.Remove(user);
//closes the active connection to SQL
UserCtrl.CloseConnection();
}
static void Main(string[] args)
{
VendorsController VendorCtrl = new VendorsController(@"dsi-workstation\SQLEXPRESS", "prssql");
IEnumerable <Vendor> vendors = VendorCtrl.List();
Vendor v1 = VendorCtrl.Get(1);
int AmazonId = v1.Id;
v1.Name = "Amazon, Inc.";
VendorCtrl.Change(v1);
v1.Id = 0;
v1.Name = "Walmart";
v1.Code = "WALM";
VendorCtrl.Create(v1);
v1.Id = 3;
VendorCtrl.Remove(v1);
VendorCtrl.CloseConnection();
/*
* UsersController UserCtrl = new UsersController(@"dsi-workstation\SQLEXPRESS", "prssql");
*
* IEnumerable<User> users = UserCtrl.List();
* foreach(User user1 in users) {
* Console.WriteLine($"{user1.Firstname} {user1.Lastname}");
* }
*
* User user = UserCtrl.Get(6);
* if(user == null) {
* Console.WriteLine("User not found");
* } else {
* Console.WriteLine($"{user.Firstname} {user.Lastname}");
* }
*
* user = UserCtrl.Get(999);
* if (user == null) {
* Console.WriteLine("User not found");
* } else {
* Console.WriteLine($"{user.Firstname} {user.Lastname}");
* }
*
* User newUser = new User();
* newUser.Username = "******";
* newUser.Password = "******";
* newUser.Firstname = "New";
* newUser.Lastname = "User";
* newUser.Phone = "513-555-1212";
* newUser.Email = "*****@*****.**";
* newUser.IsReviewer = false;
* newUser.IsAdmin = true;
*
* //bool success = UserCtrl.Create(newUser);
*
* user = UserCtrl.Get(6);
* user.Firstname = "Kimmie";
* //bool success = UserCtrl.Change(user);
*
* user = UserCtrl.Get(19);
* if(user != null)
* UserCtrl.Remove(user);
*
* UserCtrl.CloseConnection();
*
*/
}
