public ContactTableCollection FetchAll() { ContactTableCollection coll = new ContactTableCollection(); Query qry = new Query(ContactTable.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
//end append to log /// <summary> /// derive user details from submitted email address /// </summary> /// <param name="txtmail"></param> /// <returns></returns> public static String getuserAccount(string txtmail) { txtmail = wwi_security.DecryptString(txtmail, "publiship"); String _account = ""; Query _qryb = new Query(Tables.ContactTable).WHERE("Email", Comparison.Equals, txtmail).AND("Live", Comparison.Equals, true); ContactTableCollection _contact = new ContactTableCollection(); _contact.LoadAndCloseReader(_qryb.ExecuteReader()); if (_contact.Count != 0) { _account = (String)_contact[0].ContactName + "#" + (String)_contact[0].Password; } else { Query _qry = new Query(Tables.EmployeesTable).WHERE("EmailAddress", Comparison.Equals, txtmail).AND("Live", Comparison.Equals, true); EmployeesTableCollection _employ = new EmployeesTableCollection(); _employ.LoadAndCloseReader(_qry.ExecuteReader()); if (_employ.Count != 0) { _account = (String)_employ[0].Name + "#" + (String)_employ[0].Password; } } return(_account); }
protected void bind_formview(string mode) { //have to use a collection as formview needs to bind to enumerable ContactTableCollection _tbl = new ContactTableCollection(); if (mode != "Insert") { int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship")); ContactTable _ct = new ContactTable(_pid); _tbl.Add(_ct); } else { ContactTable _ct = new ContactTable(); _tbl.Add(_ct); } this.fmvContact.DataSource = _tbl; this.fmvContact.DataBind(); }
public ContactTableCollection FetchByQuery(Query qry) { ContactTableCollection coll = new ContactTableCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public ContactTableCollection FetchByID(object ContactID) { ContactTableCollection coll = new ContactTableCollection().Where("ContactID", ContactID).Load(); return coll; }
//overloaded public static int getuserIds(string username, string password, string returnid) { //should we rquire password encryption here? //string txtPassword = wwi_security.DecryptString(password, "publiship"); int _account = 0; Query _qry1 = new Query(Tables.ContactTable).WHERE("ContactName", Comparison.Equals, username).AND("Password", Comparison.Equals, password).AND("Live", Comparison.Equals, true); ContactTableCollection _contact = new ContactTableCollection(); _contact.LoadAndCloseReader(_qry1.ExecuteReader()); if (_contact.Count != 0) { _account = returnid == "user"? (int)_contact[0].ContactID : (int)_contact[0].CompanyID; } else { Query _qry2 = new Query(Tables.EmployeesTable).WHERE("Name", Comparison.Equals, username).AND("Password", Comparison.Equals, password).AND("Live", Comparison.Equals, true); EmployeesTableCollection _employ = new EmployeesTableCollection(); _employ.LoadAndCloseReader(_qry2.ExecuteReader()); if (_employ.Count != 0) { _account = returnid == "user"? (int)_employ[0].EmployeeID: -1; } } return _account; }
//end get user account /// <summary> /// derive user ids as userid#companyid for a valid login /// return empty string if login fails /// </summary> /// <param name="username">name of user</param> /// <param name="password">encrypted password</param> /// <returns></returns> public static String getuserIds(string username, string password) { //should we rquire password encryption here? //string txtPassword = wwi_security.DecryptString(password, "publiship"); String _account = ""; Query _qry1 = new Query(Tables.ContactTable).WHERE("ContactName", Comparison.Equals, username).AND("Password", Comparison.Equals, password).AND("Live", Comparison.Equals, true); ContactTableCollection _contact = new ContactTableCollection(); _contact.LoadAndCloseReader(_qry1.ExecuteReader()); if (_contact.Count != 0) { _account = _contact[0].ContactID.ToString() + "#" + (String)_contact[0].CompanyID.ToString(); } else { Query _qry2 = new Query(Tables.EmployeesTable).WHERE("Name", Comparison.Equals, username).AND("Password", Comparison.Equals, password).AND("Live", Comparison.Equals, true); EmployeesTableCollection _employ = new EmployeesTableCollection(); _employ.LoadAndCloseReader(_qry2.ExecuteReader()); if (_employ.Count != 0) { _account = _employ[0].EmployeeID.ToString() + "#-1"; //internal users do not have a company id set to -1 } } return _account; }
//end decrypt string /// <summary> /// derive user details from submitted email address /// </summary> /// <param name="txtmail"></param> /// <returns></returns> public static String getuserAccount(string txtmail) { txtmail = wwi_security.DecryptString(txtmail, "publiship"); String _account = ""; Query _qryb = new Query(Tables.ContactTable).WHERE("Email", Comparison.Equals, txtmail).AND("Live", Comparison.Equals, true); ContactTableCollection _contact = new ContactTableCollection(); _contact.LoadAndCloseReader(_qryb.ExecuteReader()); if (_contact.Count != 0) { _account = (String)_contact[0].ContactName + "#" + (String)_contact[0].Password; } else { Query _qry = new Query(Tables.EmployeesTable).WHERE("EmailAddress", Comparison.Equals, txtmail).AND("Live", Comparison.Equals, true); EmployeesTableCollection _employ = new EmployeesTableCollection(); _employ.LoadAndCloseReader(_qry.ExecuteReader()); if (_employ.Count != 0) { _account = (String)_employ[0].Name + "#" + (String)_employ[0].Password; } } return _account; }
//end bind dll archive protected void bind_combos() { //company if company is not -1 (WWI employee) if (Session["user"] != null) { Int32 _companyid = (Int32)((UserClass)Page.Session["user"]).CompanyId; Int32 _officeid = (Int32)((UserClass)Page.Session["user"]).OfficeId; if (_companyid != -1) //bind contacts for this company { //contact names Query _qry = new Query(Tables.ContactTable, "WWIprov").AddWhere("CompanyID", Comparison.Equals, _companyid).ORDER_BY("ContactName", "asc"); ContactTableCollection _contact = new ContactTableCollection(); _contact.LoadAndCloseReader(_qry.ExecuteReader()); DataTable _dt = (DataTable)_contact.ToDataTable(); this.cboName.DataSource = _dt; this.cboName.ValueField = "ContactID"; this.cboName.TextField = "ContactName"; this.cboName.DataBind(); } else //bind users by office instead { //Query _qry = new Query(Tables.EmployeesTable,"WWIprov").AddWhere("OfficeID", Comparison.Equals, _officeid).ORDER_BY("Name", "asc"); //EmployeesTableCollection _employee = new EmployeesTableCollection(); //_employee.LoadAndCloseReader(_qry.ExecuteReader()); //DataTable _dt = (DataTable)_employee.ToDataTable(); //this.cboName.DataSource = _dt; //this.cboName.ValueField = "EmployeeID"; //this.cboName.TextField = "Name"; //this.cboName.DataBind(); } //11/03/2011 append ALL USERS option as 1st item in dropdown //Code here to populate DropDownList DevExpress.Web.ASPxEditors.ListEditItem _li = new DevExpress.Web.ASPxEditors.ListEditItem("(All users)", "-1"); this.cboName.Items.Insert(0, _li); //default to all users this.cboName.SelectedIndex = 0; //250112 bind quick filter fields if user is logged in or not this.ObjectDataSourceFields.SelectMethod = "FetchByActive"; this.ObjectDataSourceFields.DataBind(); } else { //250112 bind quick filter fields if user is logged in or not this.ObjectDataSourceFields.SelectMethod = "FetchByActiveAnonymous"; this.ObjectDataSourceFields.DataBind(); } }