public Model.Home GetHomeFromId(int id)
{
SqlConnection conn = new SqlConnection(DBConnectionString);
Model.Home _home = new Model.Home();
try {
conn.Open();
SqlCommand cmd = new SqlCommand("GetHomeFromId", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter();
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
_home = new Model.Home(int.Parse(reader["ID"].ToString()), reader["Street_Address"].ToString(), int.Parse(reader["Postcode"].ToString()), reader["Region"].ToString());
}
reader.Close();
}
catch (SqlException e) {
System.Windows.MessageBox.Show(e.Message);
}
finally {
conn.Close();
conn.Dispose();
}
return(_home);
}
public Book.Model.Home GetCount()
{
Book.Model.Home home = new Model.Home();
Book.DAL.T_Base_Book book_dal = new DAL.T_Base_Book();
home.BookCount = book_dal.GetCount();
Book.DAL.T_Base_Provider provider_dal = new DAL.T_Base_Provider();
home.ProviderCount = provider_dal.GetCount();
Book.DAL.T_Base_Customer customer_dal = new DAL.T_Base_Customer();
home.CustomerCount = customer_dal.GetCount();
Book.DAL.T_Stock_In in_dal = new DAL.T_Stock_In();
home.InHeadCount = in_dal.GetCount();
Book.DAL.T_Stock_Out out_dal = new DAL.T_Stock_Out();
home.OutHeadCount = in_dal.GetCount();
return(home);
}