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)); }