private static Userinfo ReadUserinfo(IDataRecord reader)
{
var Id = reader.GetInt32(0);
var Mail = reader.GetString(1);
var Phone = reader.GetInt32(2);
var i = new Userinfo {
Id = Id, Mail = Mail, PhoneNo = Phone
};
return(i);
}
public int UpdateMail(string id, Userinfo user)
{
SqlConnection conn = new SqlConnection(GetConnectionString);
conn.Open();
string sql = $"UPDATE UserTable SET Mail = @mail, PhoneNo = @phone WHERE id = {id}";
SqlCommand command = new SqlCommand(sql, conn);
command.Parameters.AddWithValue("@mail", user.Mail);
command.Parameters.AddWithValue("@phone", user.PhoneNo);
return(command.ExecuteNonQuery());
}
