public int Insert(AccountItem item) { string query = "Insert into account(email,password,state) VALUES(@Email,@Password,@State)"; IDbParameters param = CreateDbParameters(); param.AddWithValue("Password", item.Password).DbType = DbType.String; param.AddWithValue("Email", item.Email).DbType = DbType.String; param.AddWithValue("State", item.State).DbType = DbType.String; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }
public int Update(AccountItem item) { string query = "UPDATE account SET password = @Password, email = @Email, state = @State where id = @Id"; IDbParameters param = CreateDbParameters(); param.AddWithValue("Id", item.Id).DbType = DbType.Int32; param.AddWithValue("Password", item.Password).DbType = DbType.String; param.AddWithValue("Email", item.Email).DbType = DbType.String; param.AddWithValue("State", item.State).DbType = DbType.String; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }