public void FillVendorDataList(int SocietyID, String UserType) { try { VendorController vendorController = new VendorController(); DataSet DatasetVendors = vendorController.GetVendors(muser.currentResident.SocietyID, muser.currentResident.UserType, 0); //String TotalvendorsQuery = "Select Count(ID) from dbo.vendors;"; int Totalvendors = 0; //dacess.GetSingleValue(TotalvendorsQuery); if (DatasetVendors == null || DatasetVendors.Tables == null || DatasetVendors.Tables.Count == 0 || DatasetVendors.Tables[0].Rows.Count == 0) { drpvendorfilter.Visible = false; //lblVendrCatText.Visible = false; lblVendrEmptyText.Text = "At this time there are no Vendors registered in this society"; } else { drpVendorcategory.Visible = true; //lblVendrCatText.Visible = true; DataTable dt = DatasetVendors.Tables[0]; Datavendors.DataSource = dt; Datavendors.DataBind(); Totalvendors = dt.Rows.Count; //if (dt.Rows.Count > 0) //{ // if (dt.Rows.Count == 2) // { // Datavendors.Width = new Unit("100%"); // } // if (dt.Rows.Count == 1) // { // Datavendors.Width = new Unit("100%"); // } // Datavendors.DataSource = dt; // Datavendors.DataBind(); // Totalvendors = dt.Rows.Count; //} lblTotalVendors.Text = Totalvendors.ToString(); } } catch (Exception ex) { } }
static void Main(string[] args) { var _context = new PRSContext(); var users = _context.User.ToList(); var user1 = _context.User.Find(1); user1.PhoneNumber = "513-555-1212"; _context.SaveChanges(); var control = new UsersController(_context); var user = control.Login("Steve", "SteveSteve"); var user2 = control.Login("Stevebob", "SteveSteve"); var ReqCtrl = new RequestsController(_context); var changeApprove = ReqCtrl.SetToApprove(_context.Request.Find(1)); var VendorCtrl = new VendorController(_context); var vendorList = VendorCtrl.GetVendors(); }
private void SetDataSource() { CreateLetterSearch(); bool isUnauthorized = false; if (_searchFilter == Localization.GetString("All")) { _searchFilter = ""; } else if (_searchFilter == Localization.GetString("Unauthorized")) { _searchFilter = ""; isUnauthorized = true; } //Get the list of vendors from the database var totalRecords = 0; var vendorController = new VendorController(); int portal = Globals.IsHostTab(PortalSettings.ActiveTab.TabID) ? Null.NullInteger : PortalId; if (String.IsNullOrEmpty(_searchFilter)) { grdVendors.DataSource = vendorController.GetVendors(portal, isUnauthorized, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } else { if (_searchField == "email") { grdVendors.DataSource = vendorController.GetVendorsByEmail(_searchFilter, portal, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } else { grdVendors.DataSource = vendorController.GetVendorsByName(_searchFilter, portal, grdVendors.CurrentPageIndex, grdVendors.PageSize, ref totalRecords); grdVendors.VirtualItemCount = totalRecords; } } }
private void BindData(string searchText, string searchField) { CreateLetterSearch(); //Localize the Headers Localization.LocalizeDataGrid(ref grdVendors, LocalResourceFile); if (searchText == Localization.GetString("All")) { strFilter = ""; } else if (searchText == Localization.GetString("Unauthorized")) { strFilter = ""; } else { strFilter = searchText; } //Get the list of vendors from the database var PageSize = Convert.ToInt32(ddlRecordsPerPage.SelectedItem.Value); var TotalRecords = 0; var objVendors = new VendorController(); int Portal = Globals.IsHostTab(PortalSettings.ActiveTab.TabID) ? Null.NullInteger : PortalId; if (String.IsNullOrEmpty(strFilter)) { if (searchText == Localization.GetString("Unauthorized")) { grdVendors.DataSource = objVendors.GetVendors(Portal, true, CurrentPage - 1, PageSize, ref TotalRecords); } else { grdVendors.DataSource = objVendors.GetVendors(Portal, false, CurrentPage - 1, PageSize, ref TotalRecords); } } else { if (searchField == "email") { grdVendors.DataSource = objVendors.GetVendorsByEmail(strFilter, Portal, CurrentPage - 1, PageSize, ref TotalRecords); } else { grdVendors.DataSource = objVendors.GetVendorsByName(strFilter, Portal, CurrentPage - 1, PageSize, ref TotalRecords); } } grdVendors.DataBind(); ctlPagingControl.TotalRecords = TotalRecords; ctlPagingControl.PageSize = PageSize; ctlPagingControl.CurrentPage = CurrentPage; string strQuerystring = ""; if (ddlRecordsPerPage.SelectedIndex != 0) { strQuerystring = "PageRecords=" + ddlRecordsPerPage.SelectedValue; } if (!String.IsNullOrEmpty(strFilter)) { strQuerystring += "&filter=" + strFilter; } ctlPagingControl.QuerystringParams = strQuerystring; ctlPagingControl.TabID = TabId; }
protected void Page_Load(Object sender, EventArgs e) { try { if (!Page.IsPostBack) { // Obtain banner information from the Banners table and bind to the list control BannerTypeController objBannerTypes = new BannerTypeController(); cboType.DataSource = objBannerTypes.GetBannerTypes(); cboType.DataBind(); cboType.Items.Insert(0, new ListItem(Localization.GetString("AllTypes", LocalResourceFile), "-1")); ArrayList lstVendors; VendorController objVendor = new VendorController(); lstVendors = objVendor.GetVendors(PortalId, ""); ddlVendor.DataSource = lstVendors; ddlVendor.DataTextField = "VendorName"; ddlVendor.DataValueField = "VendorId"; ddlVendor.DataBind(); ddlVendor.Items.Insert(0, new ListItem("", "0")); if (ModuleId > 0) { // Get settings from the database Hashtable settings = PortalSettings.GetModuleSettings(ModuleId); if (optSource.Items.FindByValue(Convert.ToString(settings["bannersource"])) != null) { optSource.Items.FindByValue(Convert.ToString(settings["bannersource"])).Selected = true; } else { optSource.Items.FindByValue("L").Selected = true; } if (cboType.Items.FindByValue(Convert.ToString(settings["bannertype"])) != null) { cboType.Items.FindByValue(Convert.ToString(settings["bannertype"])).Selected = true; } if (ddlVendor.Items.FindByValue(Convert.ToString(settings["vendor"])) != null) { ddlVendor.Items.FindByValue(Convert.ToString(settings["vendor"])).Selected = true; } if (optOrientation.Items.FindByValue(Convert.ToString(settings["orientation"])) != null) { optOrientation.Items.FindByValue(Convert.ToString(settings["orientation"])).Selected = true; } else { optOrientation.Items.FindByValue("V").Selected = true; } if (Convert.ToString(settings["bannercount"]) != "") { txtCount.Text = Convert.ToString(settings["bannercount"]); } else { txtCount.Text = "1"; } if (Convert.ToString(settings["border"]) != "") { txtBorder.Text = Convert.ToString(settings["border"]); } else { txtBorder.Text = "0"; } if (Convert.ToString(settings["padding"]) != "") { txtPadding.Text = Convert.ToString(settings["padding"]); } else { txtPadding.Text = "4"; } txtBorderColor.Text = Convert.ToString(settings["bordercolor"]); txtRowHeight.Text = Convert.ToString(settings["rowheight"]); txtColWidth.Text = Convert.ToString(settings["colwidth"]); } } } catch (Exception exc) //Module failed to load { Exceptions.ProcessModuleLoadException(this, exc); } }