public List <SachMuon> getSM()
{
string sql = "SELECT PhieuMuon.*, MuonSach.MaSach , Sach.TenSach FROM MuonSach, PhieuMuon, Sach WHERE MuonSach.MaPM = PhieuMuon.MaPM AND MuonSach.MaSach = Sach.MaSach";
string idPM, date, idDG, idNV, idSach, tenSach;
List <SachMuon> list = new List <SachMuon>();
Connect();
try
{
SqlDataReader dr = myExecuteReader(sql);
while (dr.Read())
{
idPM = dr[0].ToString();
date = Convert.ToDateTime(dr[1].ToString()).ToShortDateString();
idDG = dr[2].ToString();
idNV = dr[3].ToString();
idSach = dr[4].ToString();
tenSach = dr[5].ToString();
SachMuon sm = new SachMuon(idPM, date, idDG, idNV, idSach, tenSach);
list.Add(sm);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
Disconnect();
}
}
private void dgvSachChon_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
var senderGrid = (DataGridView)sender;
int index = dgvSachChon.CurrentCell.RowIndex;
int index2 = dgvPM.CurrentCell.RowIndex;
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0)
{
string idSach = dgvSachChon.Rows[index].Cells[1].Value.ToString();
string tenSach = dgvSachChon.Rows[index].Cells[2].Value.ToString();
string idPM = txtMaPM.Text;
ListViewItem item = new ListViewItem(idSach);
item.SubItems.Add(tenSach);
listView1.Items.Add(item);
SachMuon sm = new SachMuon(idPM, idSach);
int numberOfRows = new PhieuMuonBUS().AddSM(sm);
}
}
catch (SqlException ex)
{
MessageBox.Show("ThemThatBai", ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int AddSM(SachMuon sm)
{
try
{
return(new PhieuMuonDAO().AddSM(sm));
}
catch (SqlException ex)
{
throw ex;
}
}
public int AddSM(SachMuon sm)
{
string sql = "INSERT INTO MuonSach VALUES (@idPM,@idSach)";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@idPM", sm.MaPM));
parameters.Add(new SqlParameter("@idSach", sm.MaSach));
try
{
return(myExecuteNonQuery(sql, CommandType.Text, parameters));
}
catch (SqlException ex)
{
throw ex;
}
}
