public bool SuaLoaiHH(LoaiHH ch, string id) { if (ch == null) { return(false); } try { var sql = "update LoaiHH set MaLoai ='" + @ch.MaLoai + "', TenHH='" + @ch.TenLoai + "' where soCMNDChuHo='" + id + "'"; using (SqlCommand updateCommand = new SqlCommand(sql, connection)) { if (updateCommand.ExecuteNonQuery() == 1) { return(true); } return(false); } } catch { return(false); } }
public bool ThemLoaiHH(LoaiHH ch) { if (ch == null) { return(false); } try { //MaHH], [TenHH], [MaLoai string sql = "insert into " + "LoaiHH(MaLoai, TenLoai,) " + "values(@MaHH, @TenHH, @MaLoai)"; using (SqlCommand insertCommand = new SqlCommand(sql, connection)) { insertCommand.Parameters.AddWithValue("@MaLoai", ch.MaLoai); insertCommand.Parameters.AddWithValue("@TenLoai", ch.TenLoai); if (insertCommand.ExecuteNonQuery() == 1) { return(true); } } } catch { MessageBox.Show("lỗi phát sinh khi thêm loại hàng hóa.\nThử lại", "Cảnh báo", MessageBoxButtons.OK); } return(false); }
private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { try { s = new LoaiHH(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()); } catch { } }
public SuaLoaiHH(LoaiHH lhh) : this() { txtMaLoai.Text = lhh.MaLoai; txtTenLoai.Text = lhh.TenLoai; }