//NhaSx nsx = new NhaSx();
public bool ThemNhaSanXuat(NhaSx nsx)
{
try
{
bool nhasxCheck = false;
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_Insert_NHASX";
command.Connection = conn;
command.Parameters.Add("@TENSX", SqlDbType.NVarChar).Value = nsx.TenSx;
command.Parameters.Add("@QUOCGIA", SqlDbType.NVarChar).Value = nsx.QuocGia;
int result = command.ExecuteNonQuery();
if (result > 0)
{
nhasxCheck = true;
}
return(nhasxCheck);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
// Delete Nha San Xuat
public bool DeleteNhaSanXuat(NhaSx nsx)
{
bool isCheck = false;
try
{
OpenConnection();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_DELETE_NHASX";
sqlCommand.Connection = conn;
sqlCommand.Parameters.Add("@MASX", SqlDbType.Int).Value = nsx.MaSx;
int result = sqlCommand.ExecuteNonQuery();
if (result > 0)
{
isCheck = true;
}
return(isCheck);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
// Tim Kiem Nha San Xuat
public List <NhaSx> TimKiemNhaSx(NhaSx nsx)
{
try
{
OpenConnection();
List <NhaSx> nsxlist = new List <NhaSx>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_TimKiemNhaSanXuat";
sqlCommand.Connection = conn;
sqlCommand.Parameters.Add("@Search", SqlDbType.NVarChar).Value = nsx.Search;
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSx nsxs = new NhaSx();
nsxs.MaSx = int.Parse(dt.Rows[i][0].ToString());
nsxs.TenSx = dt.Rows[i][1].ToString();
nsxs.QuocGia = dt.Rows[i][2].ToString();
nsxlist.Add(nsxs);
}
sqlReader.Close();
return(nsxlist);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
public List <NhaSx> GetAllListNhaSx()
{
try
{
OpenConnection();
List <NhaSx> nsxlist = new List <NhaSx>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "SELECT *FROM dbo.NHASX";
sqlCommand.Connection = conn;
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSx nsx = new NhaSx();
nsx.MaSx = int.Parse(dt.Rows[i][0].ToString());
nsx.TenSx = dt.Rows[i][1].ToString();
nsx.QuocGia = dt.Rows[i][2].ToString();
nsxlist.Add(nsx);
}
sqlReader.Close();
return(nsxlist);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
// Loc Danh sAch Nha San Xuat
public List <NhaSx> LocDanhSachNhaSanXuat(NhaSx nsx)
{
return(nhaSaXuatAccess.LocDanhSachNhaSx(nsx));
}
// Tim kiem Nha San Xuat
public List <NhaSx> TimKiemNhaSx(NhaSx nsx)
{
return(nhaSaXuatAccess.TimKiemNhaSx(nsx));
}
public bool DeleteNhaSx(NhaSx nsx)
{
return(nhaSaXuatAccess.DeleteNhaSanXuat(nsx));
}
public bool EditNhaSx(NhaSx nsx)
{
return(nhaSaXuatAccess.SuaNhaNhaSanXuat(nsx));
}
public bool InserNhaSx(NhaSx nsx)
{
return(nhaSaXuatAccess.ThemNhaSanXuat(nsx));
}
// Loc Nha San Xuat
public List <NhaSx> LocDanhSachNhaSx(NhaSx nsx)
{
try
{
OpenConnection();
List <NhaSx> nsxlist = new List <NhaSx>();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.Text;
SqlDataReader sqlReader = null;
DataTable dt = new DataTable();
if (nsx.Search == "Mã Sản Xuất")
{
sqlCommand.CommandText = "SELECT MASX FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSx nsxs = new NhaSx();
nsxs.MaSx = int.Parse(dt.Rows[i][0].ToString());
nsxlist.Add(nsxs);
}
}
else if (nsx.Search == "Tên Sản Xuất")
{
sqlCommand.CommandText = "SELECT TENSX FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSx nsxs = new NhaSx();
nsxs.TenSx = dt.Rows[i][0].ToString();
nsxlist.Add(nsxs);
}
}
else if (nsx.Search == "Quốc Gia")
{
sqlCommand.CommandText = "SELECT DISTINCT(QUOCGIA) FROM dbo.NHASX";
sqlCommand.Connection = conn;
sqlReader = sqlCommand.ExecuteReader();
dt.Load(sqlReader);
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaSx nsxs = new NhaSx();
nsxs.QuocGia = dt.Rows[i][0].ToString();
nsxlist.Add(nsxs);
}
}
sqlReader.Close();
return(nsxlist);
}
catch
{
throw;
}
finally
{
CloseConnection();
}
}
