public bool check_user_right(string username, int requiredRight)
{
bool isSuccess = false;
using (Models.MerchantService db = new MerchantService())
{
t_Users u = db.t_Users.Where(x => x.UserID == username).SingleOrDefault();
mUser mU = new mUser();
mU.UserID = u.UserID;
mU.UserLevel = u.UserLevel;
if (requiredRight == 1)
{
if (mU.UserLevel == 1 || mU.UserLevel == 3)
{
isSuccess = true;
}
}
if (requiredRight == 2)
{
if (mU.UserLevel == 2 || mU.UserLevel == 3)
{
isSuccess = true;
}
}
}
return(isSuccess);
}
public bool UserLogin(mUser user)
{
using (SqlConnection consql = new SqlConnection(ConfigurationManager.ConnectionStrings["MerchantServiceDB"].ConnectionString))
{
consql.Open();
SqlCommand cmd = new SqlCommand("sp_u_login", consql);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@Passwd", EncryptPassword(user.Passwd));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
