public static int EditGroup(string email, SqlGroup userGroup)
{
//INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')
var sql = $"UPDATE user SET mygroup = '{userGroup.ToString()}' WHERE email = '{email}'";
using (var cmd = new MySqlCommand(sql, HyMySqlHelper.MySqlConnection))
{
var num = cmd.ExecuteNonQuery();
return(num);
}
}
public static int editGroup(string userid, SqlGroup userGroup)
{
int a = 0;
using (var db = new DataContext())
{
UserEntity userEntity = db.User
.Where(b => b.Userid.Equals(userid)).FirstOrDefault();
if (userid != null)
{
userEntity.UserGroup = userGroup.ToString();
}
a = db.SaveChanges();
}
return(a);
}
