public BECompanyUsers SelectAllInactive() { BECompanyUsers ds = new BECompanyUsers(); DACompanyUserCompanies da = new DACompanyUserCompanies(); da.SelectAllInactive(ds.tbl_CompanyUserCompanies); return ds; }
public BECompanyUsers SelectCompanyInfoByCompanyUserID(int CompanyUserID) { BECompanyUsers ds = new BECompanyUsers(); DACompanyUsers da = new DACompanyUsers(); da.SelectCompanyInfoByCompanyUserID(CompanyUserID, ds.tbl_CompanyUsers); return ds; }
public BECompanyUsers DeleteAssignedCompaniesByCompanyUserID(int CompanyUserID) { BECompanyUsers ds = new BECompanyUsers(); DACompanyUserCompanies da = new DACompanyUserCompanies(); da.DeleteAssignedCompaniesByCompanyUserID(CompanyUserID, ds.tbl_CompanyUserCompanies); return ds; }
public BECompanyUsers SelectCompanyUsersByID(int CompanyUsersID) { BECompanyUsers ds = new BECompanyUsers(); DACompanyUsers da = new DACompanyUsers(); da.SelectByID(CompanyUsersID.ToString(), ds.tbl_CompanyUsers); return ds; }
public BECompanyUsers SelectByFirstName(string SearchString) { DACompanyUsers da = new DACompanyUsers(); BECompanyUsers ds = new BECompanyUsers(); da.SelectByFirstName(SearchString, ds.tbl_CompanyUsers); return ds; }
public BECompanyUsers SelectByFirstNameCompanyID(string SearchString,int ClientID) { DACompanyUsers da = new DACompanyUsers(); BECompanyUsers ds = new BECompanyUsers(); da.SelectByFirstNameCompanyID(SearchString, ClientID, ds.tbl_CompanyUsers); return ds; }
private void Page_Load(object sender, EventArgs e) { // Put user code to initialize the page here // Put user code to initialize the page here //this.AuthenticatePage(Globals.PermissionLevels.ManageAdministrators); //if (this.CimsUser.RolePermission(Globals.PermissionLevels.ManageAdministrators) < 2) //{ //} if (IsNewSession) { AddToListIfAdmin(); IsNewSession = false; } if (!Page.IsPostBack) { BPCompanyUsers bp = new BPCompanyUsers(); DSCompanyUsers = bp.SelectCompanyUsersByID(CompanyUserID); DataBind(); } }
private void GetCompanyID() { BPCompanyUsers bp = new BPCompanyUsers(); DSCompanyUsers = bp.SelectCompanyUsersByID(Convert.ToInt32(OryxUser.OryxIdentity.MemberID)); BECompanyUsers.tbl_CompanyUsersRow companyuser = DSCompanyUsers.tbl_CompanyUsers.FindByCompanyUserID(Convert.ToInt32(OryxUser.OryxIdentity.MemberID)); CompanyID = companyuser.CompanyID; }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.DSCompanyUsers = new BECompanyUsers(); this.DSCompanyUsers.BeginInit(); this.btnCancel.Click += new EventHandler(this.btnCancel_Click); this.btnSubmit.Click += new EventHandler(this.btnSubmit_Click); // // DSCompanyUsers // this.DSCompanyUsers.DataSetName = "DSCompanyUsers"; this.DSCompanyUsers.Locale = new CultureInfo("en-US"); this.Load += new EventHandler(this.Page_Load); this.DSCompanyUsers.EndInit(); }
private void btnSubmit_Click(object sender, EventArgs e) { BPCompanyUsers bp = new BPCompanyUsers(); DSCompanyUsers = bp.SelectCompanyUsersByID(CompanyUserID); BECompanyUsers.tbl_CompanyUsersRow user = DSCompanyUsers.tbl_CompanyUsers.FindByCompanyUserID(CompanyUserID); user.CompanyUserLoginID = txtLoginName.Text; user.CompanyUserPassword = txtPassword.Text; int testCompanyUserID = bp.Login(txtLoginName.Text, txtPassword.Text); if (testCompanyUserID == 0 || testCompanyUserID == CompanyUserID) { bp.Update(DSCompanyUsers); lblErr.Text = ""; Response.Redirect(HttpUtility.UrlDecode( Request.QueryString["ReturnUrl"])); } else { lblErr.Text = "Sorry username and password taken."; } }
public BECompanyUsers SelectByLastNameCompanyGroupID(string SearchString,int CompanyGroupID) { DACompanyUsers da = new DACompanyUsers(); BECompanyUsers ds = new BECompanyUsers(); da.SelectByLastNameCompanyGroupID(SearchString, CompanyGroupID , ds.tbl_CompanyUsers); return ds; }
private void GetSelectedItems() { lstSelectedUserItems.Items.Clear(); if (CompanyGroupID != 0) { MyListViewItem listItem; BPCompanyUsers bp = new BPCompanyUsers(); BECompanyUsers ds = new BECompanyUsers(); ds = bp.SelectByCompanyGroupID(CompanyGroupID); foreach (BECompanyUsers.tbl_CompanyUsersRow user in ds.tbl_CompanyUsers) { listItem = lstSelectedUserItems.Items.Add(); listItem.CheckBox = true; listItem.ItemValue = user.CompanyUserID.ToString(); listItem.Text = user.CompanyUserFullName; } } }
private void ViewAssignedCompanies() { BPCompanyUserCompanies bp = new BPCompanyUserCompanies(); DSCompanies = bp.SelectCompanyUserCompaniesByCompanyUserID(CompanyUserID); dgAssignedCompanies.DataBind(); }
public void Update(BECompanyUsers ds) { DACompanyUsers da = new DACompanyUsers(); da.Update(ds.tbl_CompanyUsers); }
private void ShowGroupUsers() { pnlUsers.Visible = true; if (_HasChangedUsers) { BPCompanyGroups groups = new BPCompanyGroups(); BECompanyGroups.tbl_CompanyGroupsRow group; DSCompanyGroups = groups.SelectCompanyGroupsByID(CompanyGroupID); group = DSCompanyGroups.tbl_CompanyGroups.FindByCompanyGroupID(CompanyGroupID); groups.Update(DSCompanyGroups); if (_HasChangedUsers) { groups.UpdateCompanyUsers(group.CompanyGroupID, UserGroupsList); } } BPCompanyUsers bp = new BPCompanyUsers(); DSCompanyUsers = bp.SelectByCompanyGroupID(CompanyGroupID); dgUsers.DataBind(); }
public BECompanyUsers SelectAll() { BECompanyUsers ds = new BECompanyUsers(); DACompanyUsers da = new DACompanyUsers(); da.SelectAll(ds.tbl_CompanyUsers); return ds; }
private void GetCompanyLogo() { BPCompanyUsers bp = new BPCompanyUsers(); DSCompanyUsers = bp.SelectCompanyInfoByCompanyUserID(UserID); BECompanyUsers.tbl_CompanyUsersRow companyuser = DSCompanyUsers.tbl_CompanyUsers.FindByCompanyUserID(UserID); CompanyID = companyuser.CompanyID; if (!companyuser.IsCompanyImageNameNull()) { string CompanyImageName = companyuser.CompanyImageName; imgLogo.ImageUrl = "uploads/l_" + CompanyImageName; imgLogo.Visible = true; lblCompanyName.Visible = false; } else { string CompanyName = companyuser.CompanyName; imgLogo.Visible = false; lblCompanyName.Visible = true; lblCompanyName.Text = CompanyName; } }
private void SaveAssignedCompanies() { if (ChangedCompanies.Value == "true") { ArrayList _NewRelatedProductIDs = SelectedCompaniesList; BECompanyUsers.tbl_CompanyUserCompaniesRow relatedProduct; BPCompanyUserCompanies bp = new BPCompanyUserCompanies(); BECompanyUsers DSCompanies = new BECompanyUsers(); bp.DeleteAssignedCompaniesByCompanyUserID(CompanyUserID); foreach (object tmpProdID in _NewRelatedProductIDs) { relatedProduct = DSCompanies.tbl_CompanyUserCompanies.Newtbl_CompanyUserCompaniesRow(); relatedProduct.CompanyUserID = CompanyUserID; relatedProduct.CompanyID = Convert.ToInt32(tmpProdID); DSCompanies.tbl_CompanyUserCompanies.Addtbl_CompanyUserCompaniesRow(relatedProduct); } bp.Update(DSCompanies); } ViewAssignedCompanies(); }
protected void FillSelectedCompanies() { if (CompanyUserID > 0) { ChangedCompanies.Value = "false"; ddlSelectedCompanies.Items.Clear(); BPCompanyUserCompanies bp = new BPCompanyUserCompanies(); DSCompanies = bp.SelectCompanyUserCompaniesByCompanyUserID(CompanyUserID); if (DSCompanies.tbl_CompanyUserCompanies.Count > 0) { ddlSelectedCompanies.DataTextField = "CompanyName"; ddlSelectedCompanies.DataValueField = "CompanyID"; ddlSelectedCompanies.DataBind(); SelectedCompanies.Value = ""; foreach (BECompanyUsers.tbl_CompanyUserCompaniesRow content in DSCompanies.tbl_CompanyUserCompanies) { SelectedCompanies.Value += content.CompanyID + ","; } } } }
protected void FillAvailableCompanies() { ddlAvailableCompanies.Items.Clear(); BPCompanyUserCompanies bp = new BPCompanyUserCompanies(); DSCompanies = bp.SelectNonAssignedCompaniesByCompanyUserID(CompanyUserID); DSCompanies.tbl_CompanyUserCompanies.DefaultView.Sort = "CompanyName"; ddlAvailableCompanies.DataTextField = "CompanyName"; ddlAvailableCompanies.DataValueField = "CompanyID"; ddlAvailableCompanies.DataBind(); }
private void FillSearchResults(BECompanyUsers ds) { lstSearchUserResults.Items.Clear(); MyListViewItem listItem; int count = 0; lblErr.Text = string.Empty; foreach (BECompanyUsers.tbl_CompanyUsersRow user in ds.tbl_CompanyUsers) { listItem = lstSearchUserResults.Items.Add(); listItem.CheckBox = true; listItem.ItemValue = user.CompanyUserID.ToString(); listItem.Text = user.CompanyUserFullName; count++; if (count > 100) { lblErr.Text = "Sorry, list can only hold 100 users, please refine your search."; break; } } }
private void btnSubmit_ServerClick(object sender, EventArgs e) { BPCompanyUsers bp = new BPCompanyUsers(); BECompanyUsers.tbl_CompanyUsersRow CompanyUser; DSCompanyUsers = new BECompanyUsers(); if (CompanyUserID == 0) { // Add new Company CompanyUser = DSCompanyUsers.tbl_CompanyUsers.Newtbl_CompanyUsersRow(); } else { // Edit a Company DSCompanyUsers = bp.SelectCompanyUsersByID(CompanyUserID); CompanyUser = DSCompanyUsers.tbl_CompanyUsers.FindByCompanyUserID(CompanyUserID); } //all content to be updated/inserted between here CompanyUser.CompanyUserFirstName = txtCompanyUserFirstName.Text; CompanyUser.CompanyUserLastName = txtCompanyUserLastName.Text; if (ddlCompanyUserCompanyID.SelectedValue != "-1") { CompanyUser.CompanyID = Convert.ToInt32(ddlCompanyUserCompanyID.SelectedValue); } CompanyUser.CompanyUserEmail = txtCompanyUserEmail.Text; CompanyUser.CompanyUserAddress1 = txtCompanyUserAddress1.Text; CompanyUser.CompanyUserAddress2 = txtCompanyUserAddress2.Text; CompanyUser.CompanyUserCity = txtCompanyUserCity.Text; CompanyUser.CompanyUserProvince = txtCompanyUserProvince.Text; CompanyUser.CompanyUserCountry = txtCompanyUserCountry.Text; CompanyUser.CompanyUserPostalCode = txtCompanyUserPostalCode.Text; CompanyUser.CompanyUserPhone = txtCompanyUserPhone.Text; CompanyUser.CompanyUserFax = txtCompanyUserFax.Text; CompanyUser.CompanyUserActive = chkCompanyUserActive.Checked; if(CompanyUserID == 0) { CompanyUser.CompanyUserPassword = ""; CompanyUser.CompanyUserLoginID = CompanyUser.CompanyUserFirstName.Substring(0, 1) + CompanyUser.CompanyUserLastName; } CompanyUser.DateModified = DateTime.Now; CompanyUser.ModifiedByAdminID = Convert.ToInt32(OryxUser.OryxIdentity.MemberID); //all content to be updated/inserted between here if (CompanyUserID == 0) { //Add new Application Category CompanyUser.DateCreated = DateTime.Now; DSCompanyUsers.tbl_CompanyUsers.Addtbl_CompanyUsersRow(CompanyUser); } bp.Update(DSCompanyUsers); //if (CompanyUserID == 0) //{ // Response.Redirect("EditCompanyUsers.aspx?CompanyUserID=" + CompanyUser.CompanyUserID); //} //else //{ Response.Redirect("BrowseCompanyUsers.aspx"); //} }
private void btnSearch_Click(object sender, EventArgs e) { BPCompanyUsers users = new BPCompanyUsers(); if(ddlSearchBy.SelectedValue == "firstNames") { if (ddlGroups.SelectedValue == "-99") { DSCompanyUsers = users.SelectByFirstName(txtSearch.Text); } else { DSCompanyUsers = users.SelectByFirstNameCompanyID(txtSearch.Text, Convert.ToInt32(ddlGroups.SelectedValue)); } } else //if (ddlSearchBy.SelectedValue == "lastNames") { if (ddlGroups.SelectedValue == "-99") { DSCompanyUsers = users.SelectByLastName(txtSearch.Text); } else { DSCompanyUsers = users.SelectByLastNameCompanyID(txtSearch.Text, Convert.ToInt32(ddlGroups.SelectedValue)); } } FillSearchResults(DSCompanyUsers); }
private void btnDelete_Click(object sender, EventArgs e) { BPCompanyUsers bp = new BPCompanyUsers(); BECompanyUsers.tbl_CompanyUsersRow CompanyUser; DSCompanyUsers = bp.SelectCompanyUsersByID(CompanyUserID); CompanyUser = DSCompanyUsers.tbl_CompanyUsers.FindByCompanyUserID(CompanyUserID); CompanyUser.Delete(); bp.Update(DSCompanyUsers); Response.Redirect("BrowseCompanyUsers.aspx"); }