public void Execute()
{
NhaCungCap.Domain.NhaCungCap check = null;
using (var cmd = new NhaCungCapViewBusiness())
{
cmd.item = item;
check = cmd.Execute();
}
if (check != null) // da co du lieu
{
using (var cmd = new NhaCungCapUpdateBusiness())
{
cmd.item = item;
cmd.Execute();
}
}
else
{
using (var cmd = new NhaCungCapAddRepository())
{
cmd.item = item;
cmd.Execute();
}
}
}
public NhaCungCap.Domain.NhaCungCap Execute()
{
NhaCungCap.Domain.NhaCungCap data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM NhaCungCap WHERE NhacungcapId='" + item.NhacungcapId + "'";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
data = new NhaCungCap.Domain.NhaCungCap
{
NhacungcapId = Convert.ToString(reader["NhacungcapId"]),
Ten = Convert.ToString(reader["Ten"]),
HangHoaCungCap = Convert.ToString(reader["HangHoaCungCap"]),
NhomhanghoaId = Convert.ToString(reader["NhomhanghoaId"]),
SDT = Convert.ToString(reader["SDT"]),
Diachi = Convert.ToString(reader["Diachi"])
};
}
}
conn.Close();
}
}
return(data);
}
