public NhomHanghoa Execute()
{
NhomHanghoa data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM NhomHanghoa WHERE NhomHanghoaId = @NhomHanghoaId";
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@NhomHanghoaId", Value = this.NhomHanghoaId, SqlDbType = System.Data.SqlDbType.NVarChar
});
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data = new NhomHanghoa();
data.NhomHanghoaId = Convert.ToString(reader["NhomHanghoaId"].vSafe());
data.TenNhomHanghoa = Convert.ToString(reader["TenNhomHanghoa"].vSafe());
data.Ghichu = Convert.ToString(reader["Ghichu"].vSafe());
}
}
}
conn.Close();
}
return(data);
}
public void Execute()
{
NhomHanghoa check = null;
using (var repo = new NhomHanghoaViewRepository())
{
repo.NhomHanghoaId = this.item.NhomHanghoaId;
check = repo.Execute();
}
if (check != null) //đã tồn tại
{
using (var repo = new NhomHanghoaUpdateRepository())
{
repo.item = this.item;
repo.Execute();
}
}
else
{
using (var repo = new NhomHanghoaInsertRepository())
{
repo.item = this.item;
repo.Execute();
}
}
}
