public static int Add(PhieuMuonDto pm)
{
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Insert into PhieuMuon(MDocGia,NgayMuon,SoNgayMuon) values (?,?,?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MDocGia", OleDbType.Integer);
cmd.Parameters.Add("@NgayMuon", OleDbType.Date);
cmd.Parameters.Add("@SoNgayMuon", OleDbType.Integer);
cmd.Parameters["@MDocGia"].Value = pm.MDocGia;
cmd.Parameters["@NgayMuon"].Value = pm.NgayMuon;
cmd.Parameters["@SoNgayMuon"].Value = pm.SoNgayMuon;
cmd.ExecuteNonQuery();
strSQL = "Select @@IDENTITY";
cmd = new OleDbCommand(strSQL, cn);
pm.MPhieu = (int)cmd.ExecuteScalar();
cn.Close();
return pm.MPhieu;
}
public static IList GetList()
{
ArrayList ds = new ArrayList();
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Select * From PhieuMuon";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
PhieuMuonDto pm = new PhieuMuonDto();
pm.MPhieu = (int)dr["MPhieu"];
pm.MDocGia = (int)dr["MDocGia"];
pm.NgayMuon = (DateTime)dr["NgayMuon"];
pm.SoNgayMuon = (int)dr["SoNgayMuon"];
ds.Add(pm);
}
dr.Close();
cn.Close();
return ds;
}
private void btDongy_Click(object sender, EventArgs e)
{
try
{
if (docgia == null)
{
MessageBox.Show("Bạn chưa chọn độc giả !!");
return;
}
if ((DataTable)dtgSachchon.DataSource == null)
{
MessageBox.Show("Bạn chưa chọn sách mượn !!");
return;
}
if (((DataTable)dtgSachchon.DataSource).Rows.Count == 0)
{
MessageBox.Show("Bạn chưa chọn sách mượn !!");
return;
}
PhieuMuonDto phieu = new PhieuMuonDto();
int count;
phieu.MDocGia = docgia.MDocGia;
phieu.NgayMuon = dayNgaymuon.Value;
phieu.SoNgayMuon = (int)numSongaymuon.Value;
phieu.TrangThai = trangThai;
if (sachlist != null)
for (count = 0; count < sachlist.Tables[0].Rows.Count; count++ )
if (trangThai == false)
{
BUS.SachBus.UpdateTrangThai((int)sachlist.Tables[0].Rows[count][0], true);
}
if (type == 0)
{
int maphieu = BUS.PhieuMuonBus.Add(phieu);
DataTable dt = (DataTable)dtgSachchon.DataSource;
ChiTietPhieuMuonDto chitiet = new ChiTietPhieuMuonDto();
chitiet.MaPhieu = maphieu;
for (count = 0; count < dt.Rows.Count; count++)
{
chitiet.MaSach = int.Parse(dt.Rows[count][1].ToString());
BUS.ChiTietPhieuMuonBus.Add(chitiet);
BUS.SachBus.UpdateTrangThai(chitiet.MaSach, false);
}
MessageBox.Show("Lập phiếu thành công");
this.Close();
}
else
{
BUS.PhieuMuonBus.Delete(mPhieu);
int maphieu = BUS.PhieuMuonBus.Add(phieu);
DataTable dt = (DataTable)dtgSachchon.DataSource;
ChiTietPhieuMuonDto chitiet = new ChiTietPhieuMuonDto();
chitiet.MaPhieu = maphieu;
for (count = 0; count < dt.Rows.Count; count++)
{
chitiet.MaSach = int.Parse(dt.Rows[count][1].ToString());
BUS.ChiTietPhieuMuonBus.Add(chitiet);
if (trangThai == false)
BUS.SachBus.UpdateTrangThai(chitiet.MaSach, false);
}
MessageBox.Show("Sửa phiếu thành công");
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static PhieuMuonDto Search(int MaPh)
{
PhieuMuonDto pm = null;
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Select * From PhieuMuon Where MPhieu= ? ";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MPhieu", OleDbType.Integer);
cmd.Parameters["@MPhieu"].Value = MaPh;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
pm = new PhieuMuonDto();
pm.MPhieu = (int)dr["MPhieu"];
pm.MDocGia = (int)dr["MDocGia"];
pm.NgayMuon = (DateTime)dr["NgayMuon"];
pm.SoNgayMuon = (int)dr["SoNgayMuon"];
}
dr.Close();
cn.Close();
return pm;
}
public static void Update(PhieuMuonDto pm)
{
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL;
strSQL = "Update PhieuMuon Set MDocGia = ? , NgayMuon = ? , SoNgayMuon = ? Where MPhieu = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MDocGia", OleDbType.Integer);
cmd.Parameters.Add("@NgayMuon", OleDbType.Date);
cmd.Parameters.Add("@SoNgayMuon", OleDbType.Integer);
cmd.Parameters.Add("@MPhieu", OleDbType.Integer);
cmd.Parameters["@MDocGia"].Value = pm.MDocGia;
cmd.Parameters["@NgayMuon"].Value = pm.NgayMuon;
cmd.Parameters["@SoNgayMuon"].Value = pm.SoNgayMuon;
cmd.Parameters["@MPhieu"].Value = pm.MPhieu;
cmd.ExecuteNonQuery();
cn.Close();
}
