public override bool UserInfoUpdate(UserInfo user)
{
DBCommands.PopulateParams("@UserName", user.UserName);
DBCommands.PopulateParams("@ProfileImage", user.ProfileImage);
DBCommands.PopulateParams("@RecoverCode", user.RecoverCode);
DBCommands.PopulateParams("@GroupUsers", MapGroupListToTable(user.GroupUsers));
return(DBCommands.ExecuteNonQuery("p_UserInfo_Update"));
}
public override UserInfo UserInfoGetByUser(string userName)
{
DBCommands.PopulateParams("@UserName", userName);
DataTable userData = DBCommands.AdapterFill("p_UserInfo_GetByUser");
UserInfo user = new UserInfo();
foreach (DataRow row in userData.Rows)
{
user.UserName = row["UserName"].ToString();
user.Email = row["Email"].ToString();
user.ProfileImage = (row["ProfileImage"] != DBNull.Value) ? row["ProfileImage"].ToString() : null;
}
return(user);
}
public override UserInfo UserInfoGetByCode(string code)
{
DBCommands.PopulateParams("@code", code);
DataTable userTable = DBCommands.AdapterFill("p_UserInfo_GetByCode");
UserInfo user = null;
foreach (DataRow row in userTable.Rows)
{
user = new UserInfo();
user.UserInfoID = Convert.ToInt32(row["UserInfoID"]);
user.UserName = row["UserName"].ToString();
user.Email = (row["Email"] != DBNull.Value) ? row["Email"].ToString() : null;
user.ProfileImage = (row["ProfileImage"] != DBNull.Value) ? row["ProfileImage"].ToString() : null;
user.RecoverCode = code;
}
return(user);
}
public override DataTable GroupUsersGetByUserName(string userName)
{
DBCommands.PopulateParams("@UserName", userName);
return(DBCommands.AdapterFill("p_GroupUsers_GetByUserName"));
}