public Owner_List GetByID(int ID)
{
Owner_List owner = new Owner_List();
using (var connection = new SqlConnection(_connectionString))
{
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetOwnerByID";
cmd.Parameters.AddWithValue(@"ID_Owner", ID);
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
owner.ID_Owner = (int)reader["ID_Owner"];
owner.Name = (string)reader["Name"];
owner.Second_Name = (string)reader["Second_Name"];
owner.Phone_Number = (string)reader["Phone_Number"];
}
}
return(owner);
}
//private string _connectionString = @"Data Source=1-vaio;Initial Catalog=UTILITIES3;Integrated Security=True";
public void Add(Owner_List value)
{
using (var connection = new SqlConnection(_connectionString))
{
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddOwner";
cmd.Parameters.AddWithValue(@"Name", value.Name);
cmd.Parameters.AddWithValue(@"Second_Name", value.Second_Name);
cmd.Parameters.AddWithValue(@"Phone_Number", value.Phone_Number);
var id = new SqlParameter
{
DbType = DbType.Int32,
ParameterName = "@ID_Owner",
Direction = ParameterDirection.Output
};
//cmd.Parameters.Add(id);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public void Add(Owner_List value)
{
owner_ListDao.Add(value);
}
