public bool Xoaloaisanpham(DTO.Loaisanpham lsp)
{
string sql = "UPDATE LOAISANPHAM SET XOA = 1 WHERE MALOAI = @MALOAI";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MALOAI", SqlDbType.Int).Value = lsp.MALOAI1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Themloaisanpham(DTO.Loaisanpham lsp)
{
string sql = "INSERT INTO LOAISANPHAM(TENLOAI)values (@TENLOAI)";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@TENLOAI", SqlDbType.NVarChar).Value = lsp.TENLOAI1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Sualoaisanpham(DTO.Loaisanpham lsp)
{
return(lspd.Sualoaisanpham(lsp));
}
public bool Xoaloaisanpham(DTO.Loaisanpham lsp)
{
return(lspd.Xoaloaisanpham(lsp));
}
public bool Themloaisanpham(DTO.Loaisanpham lsp)
{
return(lspd.Themloaisanpham(lsp));
}