public bool Sua(TuaSachDTO edit) { string query = string.Empty; query += "UPDATE TuaSach SET [Matuasach] = @Matuasach, [Tuasach] = @Tuasach, [Matheloai] = @Matheloai, [Matacgia] = @Matacgia,"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@Matuasach", edit.Matuasach); cmd.Parameters.AddWithValue("@Tuasach", edit.Tuasach); cmd.Parameters.AddWithValue("@Matheloai", edit.Matheloai); cmd.Parameters.AddWithValue("@Matacgia", edit.Matacgia); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool Xoa(TuaSachDTO del) { string query = string.Empty; query += "DELETE FROM TuaSach WHERE [Matuasach] = @Matuasach"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@Matuasach", del.Matuasach); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
//public string ConnectionString { get => connectionString; set => connectionString = value; } public bool Them(TuaSachDTO add) { string query = string.Empty; query += "INSERT INTO TuaSach ([Matuasach], [Tuasach], [Matheloai], [Matacgia]) "; query += "VALUES (@Matuasach,@Tuasach,@Matheloai,@Matacgia)"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@Matuasach", add.Matuasach); cmd.Parameters.AddWithValue("@Tuasach", add.Tuasach); cmd.Parameters.AddWithValue("@Matheloai", add.Matheloai); cmd.Parameters.AddWithValue("@Matacgia", add.Matacgia); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
private void Them_bt_Click_1(object sender, EventArgs e) { if (DauSach.check(nxb_tb.Text, namxb_tb.Text) == true && tuasach.kiemtra(tensach_tb.Text) == false) { MessageBox.Show("Đã tồn tại"); } else { TuaSachDTO tuaSach = new TuaSachDTO(); tuaSach.Matacgia = Convert.ToString(tacGia.mathetacgia(tacgia_cb.Text) + 1); tuaSach.Matheloai = Convert.ToString(theLoai.matheloai(theloai_cb.Text) + 1); tuaSach.Matuasach = MaTuDongTuaSach(tensach_tb.Text); tuaSach.Tuasach = tensach_tb.Text; DauSachDTO dauSach = new DauSachDTO(); dauSach.Namxb = namxb_tb.Text; dauSach.Nxb = nxb_tb.Text; dauSach.Soluong = Convert.ToInt32(soluong_tb.Text); dauSach.Madausach = DauSach.getds() + 1; dauSach.Matuasach = tuaSach.Matuasach; dauSach.Trigia = float.Parse(namxb_tb.Text); SachDTO sach = new SachDTO(); sach.Madausach = dauSach.Madausach; //sach.Masach = MaTuDongSach(); sach.Tinhtrang = "Còn"; sach.Ngaynhap = Convert.ToDateTime(DateTime.Now); ngaynhap.Value = DateTime.Now; // neu tua sach khac thi them tat ca int soluongsach = list.soluongsach(); int year = sach.Ngaynhap.Year - Convert.ToInt32(namxb_tb.Text); if (year > sach.Nam) { MessageBox.Show("Chỉ nhập sách trong vòng 8 năm", "Lỗi", MessageBoxButtons.OK); } else { if (tuasach.kiemtra(tensach_tb.Text) == true) { tuasach.Them(tuaSach); DauSach.add(dauSach); for (int i = soluongsach; i < soluongsach + dauSach.Soluong; i++) { sach.Masach = i; list.Them(sach); } MessageBox.Show("Thêm Thành Công", "Thông Báo", MessageBoxButtons.OK); } } } }
private void Them_bt_Click_1(object sender, EventArgs e) { if (DauSach.check(nxb_tb.Text, namxb_tb.Text) == true && tuasach.kiemtra(tensach_tb.Text) == false) { MessageBox.Show("Đã tồn tại"); } else { TuaSachDTO tuaSach = new TuaSachDTO(); tuaSach.Matacgia = Convert.ToString(tacGia.mathetacgia(tacgia_cb.Text) + 1); tuaSach.Matheloai = Convert.ToString(theLoai.matheloai(theloai_cb.Text) + 1); tuaSach.Matuasach = MaTuDongTuaSach(tensach_tb.Text); tuaSach.Tuasach = tensach_tb.Text; DauSachDTO dauSach = new DauSachDTO(); dauSach.Namxb = namxb_tb.Text; dauSach.Nxb = nxb_tb.Text; dauSach.Soluong = Convert.ToInt32(soluong_tb.Text); dauSach.Madausach = DauSach.getds() + 1; dauSach.Matuasach = tuaSach.Matuasach; dauSach.Trigia = float.Parse(namxb_tb.Text); SachDTO sach = new SachDTO(); sach.Madausach = dauSach.Madausach; //sach.Masach = MaTuDongSach(); sach.Tinhtrang = "Còn"; sach.Ngaynhap = Convert.ToDateTime(ngaynhap.Value.ToShortDateString()); // neu tua sach khac thi them tat ca int soluongsach = list.soluongsach(); if (tuasach.kiemtra(tensach_tb.Text) == true) { tuasach.Them(tuaSach); DauSach.add(dauSach); for (int i = soluongsach; i < soluongsach + dauSach.Soluong; i++) { sach.Masach = i; list.Them(sach); } } } }
public bool Sua(TuaSachDTO kn) { bool re = TsDAL.Sua(kn); return(re); }
public bool Them(TuaSachDTO dg) { bool re = TsDAL.Them(dg); return(re); }