public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
MembershipUserCollection col = new MembershipUserCollection();
RobotStandardTableAdapters.usersTableAdapter userAdapter = new RobotStandardTableAdapters.usersTableAdapter();
//string Sql = "delete from "+tableName+" where "+userLoginField+" = " + dao.ToSql(username, FieldType.Text);
//dao.ExecuteNonQuery(Sql);
return true;
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
RobotStandardTableAdapters.usersTableAdapter userAdapter = new RobotStandardTableAdapters.usersTableAdapter();
RobotStandard.usersDataTable userTbl = userAdapter.GetDataByLogin(username);
MembershipUser u = null;
try
{
if (userTbl.Rows.Count> 0)
{
u = new MembershipUser("SoftsmartMembershipProvider", userTbl.Rows[0][userLoginField].ToString(), userTbl.Rows[0][userIdField].ToString(), null, null, null, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now); ;
}
}
catch (Exception e)
{
throw e;
}
return u;
}
public override bool ValidateUser(string username, string password)
{
MembershipUserCollection col = new MembershipUserCollection();
RobotStandardTableAdapters.usersTableAdapter userAdapter = new RobotStandardTableAdapters.usersTableAdapter();
RobotStandard.usersDataTable userTable = userAdapter.GetDataByLogin(username);
string encpassword="";
/*if(ConfigurationManager.AppSettings["ProtectPasswordsMethod"]=="DBFunction")
{
encpassword = ConfigurationManager.AppSettings["ProtectPasswordsExpression"].Replace("{password}", password);
}
else if(ConfigurationManager.AppSettings["ProtectPasswordsMethod"]=="CodeExpression")
{*/
encpassword = Smart.Md5Encrypt(password) + ((userTable.Rows.Count > 0) ? userTable.Rows[0]["password_salt"].ToString() : "");
/* }
else
{
encpassword = password;
}*/
if (userTable.Rows.Count > 0 && userTable.Rows[0][userPasswordField].ToString().Equals(encpassword))
{
HttpContext.Current.Session[userIdSessionVariable] = userTable.Rows[0][userIdField].ToString();
HttpContext.Current.Session[userGroupSessionVariable] = "1" ;
HttpContext.Current.Session[userLoginSessionVariable] = username;
return true;
}
return false;
}
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
MembershipUserCollection col = new MembershipUserCollection();
RobotStandardTableAdapters.usersTableAdapter userAdapter = new RobotStandardTableAdapters.usersTableAdapter();
RobotStandard.usersDataTable userTable = userAdapter.GetData();
int counter = 0;
int startIndex = pageSize * pageIndex;
int endIndex = startIndex + pageSize - 1;
totalRecords = (int)userTable.Rows.Count;
foreach(DataRow dr in userTable.Rows)
{
if (counter >= startIndex)
{
MembershipUser user = new MembershipUser("SoftsmartMembershipProvider", dr[userLoginField].ToString(), dr[userIdField].ToString(), null, null, null, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
col.Add(user);
}
if (counter >= endIndex) { break; }
counter++;
}
return col;
}
