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