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");
}
