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