public int GetEmail(string email, string userId = "")
{
int userID = -1;
bool ignoreCurrentUser = false;
UserData userData = new UserData();
ColumnDataHelper columnDH = new ColumnDataHelper();
columnDH.Fields.Add("email");
columnDH.FieldValues.Add(email);
columnDH.FieldTypes.Add(typeof(string));
if (!String.IsNullOrEmpty(userId))
{
ignoreCurrentUser = true;
columnDH.Fields.Add("userid");
columnDH.FieldValues.Add(userId);
columnDH.FieldTypes.Add(typeof(int));
}
DataTable dt = userData.GetRecords(columnDH.GetWhereClause(ignoreCurrentUser));
if (dt.Rows.Count > 0)
{
userID = Convert.ToInt32(dt.Rows[0]["userID"].ToString());
}
return(userID);
}
public int GetLoginData(string email, string paswoord)
{
int userID = -1;
UserData userData = new UserData();
ColumnDataHelper columnDH = new ColumnDataHelper();
columnDH.Fields.Add("email");
columnDH.FieldValues.Add(email);
columnDH.FieldTypes.Add(typeof(string));
columnDH.Fields.Add("paswoord");
columnDH.FieldValues.Add(paswoord);
columnDH.FieldTypes.Add(typeof(string));
DataTable dt = userData.GetRecords(columnDH.GetWhereClause());
if (dt.Rows.Count > 0)
{
userID = Convert.ToInt32(dt.Rows[0]["userID"].ToString());
}
return(userID);
}