public KhachHang.Domain.KhachHang Execute()
{
KhachHang.Domain.KhachHang data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM KhachHang WHERE KhachhangId='" + item.KhachhangId + "'";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
data = new KhachHang.Domain.KhachHang
{
KhachhangId = Convert.ToString(reader["KhachhangId"]),
Ho = Convert.ToString(reader["Ho"]),
Tenlot = Convert.ToString(reader["Tenlot"]),
Ten = Convert.ToString(reader["Ten"]),
Gioitinh = Convert.ToBoolean(reader["Gioitinh"]),
SDT = Convert.ToString(reader["SDT"]),
Diachi = Convert.ToString(reader["Diachi"])
};
}
}
conn.Close();
}
}
return(data);
}
public void Execute()
{
KhachHang.Domain.KhachHang check = null;
using (var cmd = new KhachHangViewBusiness())
{
cmd.item = item;
check = cmd.Execute();
}
if (check != null) // da co du lieu
{
using (var cmd = new KhachHangUpdateBusiness())
{
cmd.item = item;
cmd.Execute();
}
}
else
{
using (var cmd = new KhachHangAddRepository())
{
cmd.item = item;
cmd.Execute();
}
}
}
