public void Execute()
{
HangHoa.Domain.HangHoa check = null;
using (var cmd = new HangHoaViewBusiness())
{
cmd.item = item;
check = cmd.Execute();
}
if (check != null) // da co du lieu
{
using (var cmd = new HangHoaUpdateBusiness())
{
cmd.item = item;
cmd.Execute();
}
}
else
{
using (var cmd = new HangHoaAddRepository())
{
cmd.item = item;
cmd.Execute();
}
}
}
public HangHoa.Domain.HangHoa Execute()
{
HangHoa.Domain.HangHoa data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM HangHoa WHERE HanghoaId='" + item.HanghoaId + "'";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
data = new HangHoa.Domain.HangHoa
{
HanghoaId = Convert.ToString(reader["HanghoaId"]),
TenHanghoa = Convert.ToString(reader["TenHanghoa"]),
GiaBan = Convert.ToInt32(reader["GiaBan"]),
Mota = Convert.ToString(reader["Mota"]),
SoLuongTonKho = Convert.ToInt32(reader["SoLuongTonKho"]),
NhomHanghoaId = Convert.ToString(reader["NhomHanghoaId"])
};
}
}
conn.Close();
}
}
return(data);
}
