public static SignupUser GetSignupUser(SignupUser user)
{
using (SqlConnection sqlCon = con)
{
sqlCon.Open();
SqlCommand cmd = new SqlCommand("GetSignupUser", sqlCon);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", user.Username);
cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(user.Password));
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
return(new SignupUser
{
Id = Convert.ToInt32(dr[1]),
Username = dr[2].ToString(),
Gender = dr[4].ToString(),
Age = Convert.ToInt32(dr[5]),
});
}
}
return(null);
}
public static bool AddNewMod(Mod mod)
{
using (SqlConnection sqlCon = con)
{
sqlCon.Open();
SqlCommand cmd = new SqlCommand("AddNewMod", sqlCon);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", mod.Username);
cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(mod.Password));
return(Convert.ToInt32(cmd.ExecuteScalar()) == 1 ? true : false);
}
}
public static bool SignupNewUser(SignupUser user)
{
using (SqlConnection sqlCon = con)
{
sqlCon.Open();
SqlCommand cmd = new SqlCommand("SignupNewUser", sqlCon);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", user.Id);
cmd.Parameters.AddWithValue("@Username", user.Username);
cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(user.Password));
cmd.Parameters.AddWithValue("@Gender", user.Gender);
cmd.Parameters.AddWithValue("@Age", user.Age);
return(Convert.ToInt32(cmd.ExecuteScalar()) == 1 ? true : false);
}
}
public static bool ValidateMod(Mod mod)
{
using (SqlConnection sqlCon = con)
{
sqlCon.Open();
SqlCommand cmd = new SqlCommand("ValidateMod", sqlCon);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", mod.Username);
cmd.Parameters.AddWithValue("@Password", SharedSupport.MD5Encrypt(mod.Password));
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
return(true);
}
}
return(false);
}
