public bool ThemSize(BangSize_DTO size)
{
SqlConnection con = DataProvider.TaoKetNoi();
string query = "ThemSize";
SqlCommand cm = new SqlCommand(query, con);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@idGiay", size.idGiay);
cm.Parameters.AddWithValue("@sizeGiay", size.sizeGiay);
cm.Parameters.AddWithValue("@giaBan", size.giaBan);
cm.Parameters.AddWithValue("@giaNhap", size.giaNhap);
cm.Parameters.AddWithValue("@soLuong", size.soLuong);
cm.Parameters.AddWithValue("@trangThai", size.trangThai);
int NumOfRow = cm.ExecuteNonQuery();
con.Close();
if (NumOfRow > 0)
{
return(true);
}
else
{
return(false);
}
}
private void cbSize_SelectedIndexChanged(object sender, EventArgs e)
{
BangSize_DTO size = (cbSize.SelectedItem as BangSize_DTO);
SLTon = size.soLuong;
LoadSL();
txtGia.Text = size.giaBan.ToString();
}
public List <BangSize_DTO> LayDanhSach(int id)
{
List <BangSize_DTO> listSizeGiay = new List <BangSize_DTO>();
SqlConnection con = DataProvider.TaoKetNoi();
if (con != null)
{
SqlCommand command = new SqlCommand();
command.CommandText = @"Select * FROM BangSize WHERE trangThai = 1 and idGiay = " + id;
command.Connection = con;
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
BangSize_DTO bangSize = new BangSize_DTO();
if (dataReader.IsDBNull(0) != null)
{
bangSize.idGiay = (int)dataReader[0];
}
if (dataReader.IsDBNull(1) != null)
{
bangSize.sizeGiay = dataReader["sizeGiay"].ToString();
}
if (dataReader.IsDBNull(2) != null)
{
bangSize.giaBan = (int)dataReader["giaBan"];
}
if (dataReader.IsDBNull(3) != null)
{
bangSize.giaNhap = (int)dataReader["giaNhap"];
}
if (dataReader.IsDBNull(4) != null)
{
bangSize.soLuong = (int)dataReader["soLuong"];
}
if (dataReader.IsDBNull(5) != null)
{
bangSize.trangThai = (int)dataReader["trangThai"];
}
listSizeGiay.Add(bangSize);
}
dataReader.Close();
con.Close();
}
return(listSizeGiay);
}
public bool Sua(BangSize_DTO size)
{
BangSize_DAO objBangSize_DAO = new BangSize_DAO();
return(objBangSize_DAO.SuaSize(size));
}
public bool Them(BangSize_DTO size)
{
BangSize_DAO objBangSize_DAO = new BangSize_DAO();
return(objBangSize_DAO.ThemSize(size));
}
public bool KiemTra(BangSize_DTO size)
{
BangSize_DAO bangsize_dao = new BangSize_DAO();
return(bangsize_dao.KiemTra(size.idGiay, size.sizeGiay));
}
