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