public List <LoaiGiay_DTO> LayDanhSach(int id)
{
List <LoaiGiay_DTO> listLG = new List <LoaiGiay_DTO>();
SqlConnection con = DataProvider.TaoKetNoi();
if (con != null)
{
SqlCommand command = new SqlCommand();
command.CommandText = @"Select * FROM LoaiGiay WHERE trangThai = 1 and idHang = " + id;
command.Connection = con;
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
LoaiGiay_DTO lg = new LoaiGiay_DTO();
if (dataReader.IsDBNull(0) != null)
{
lg.id = (int)dataReader[0];
}
if (dataReader.IsDBNull(1) != null)
{
lg.tenLoaiGiay = dataReader["tenLoaiGiay"].ToString();
}
if (dataReader.IsDBNull(2) != null)
{
lg.idHang = (int)dataReader["idHang"];
}
if (dataReader.IsDBNull(3) != null)
{
lg.trangThai = (int)dataReader["trangThai"];
}
listLG.Add(lg);
}
dataReader.Close();
con.Close();
}
return(listLG);
}
private void tvHangGiay_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
TreeNode node = new TreeNode();
node = e.Node;
if (node.Text == "Tất Cả")
{
LoadGiay();
return;
}
try
{
HangGiay_DTO hanggiay = (node.Tag as HangGiay_DTO);
LoadGiayTheoHang(hanggiay.id);
}
catch
{
LoaiGiay_DTO loaigiay = (node.Tag as LoaiGiay_DTO);
LoadGiayTheoLoaiGiay(loaigiay.id);
}
}
public bool ThemLoaiGiay(LoaiGiay_DTO lg)
{
SqlConnection con = DataProvider.TaoKetNoi();
string query = "ThemLoaiGiay";
SqlCommand cm = new SqlCommand(query, con);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@tenLoaiGiay", lg.tenLoaiGiay);
cm.Parameters.AddWithValue("@idHang", lg.idHang);
cm.Parameters.AddWithValue("@trangThai", 1);
int NumOfRow = cm.ExecuteNonQuery();
con.Close();
if (NumOfRow > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Sua(LoaiGiay_DTO lg)
{
LoaiGiay_DAO objLoaiGiay_DAO = new LoaiGiay_DAO();
return(objLoaiGiay_DAO.SuaLoaiGiay(lg));
}
public bool Them(LoaiGiay_DTO lg)
{
LoaiGiay_DAO objLoaiGiay_DAO = new LoaiGiay_DAO();
return(objLoaiGiay_DAO.ThemLoaiGiay(lg));
}
