public List <CTPT> getAll(string Top, string Where, string Order)
{
List <CTPT> lst = new List <CTPT>();
string selectQuery = "select ";
if (Top.Length != 0)
{
selectQuery += "Top " + Top;
}
selectQuery += "* ";
selectQuery += "from tb_CTPT ";
if (Where.Length != 0)
{
selectQuery += "Where " + Where;
}
if (Order.Length != 0)
{
selectQuery += "Order by " + Order;
}
using (SqlCommand cmd = new SqlCommand(selectQuery, openConnection()))
{
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
CTPT obj = new CTPT();
obj.CTPTIDataReader(dr);
lst.Add(obj);
}
dr.Close();
}
return(lst);
}
public bool updateData(CTPT data)
{
bool check = false;
String sql = String.Format("UPDATE tb_CTPT SET maPT ='{0}', maSach ='{1}', thanhTien ='{2}' where maCTPT ='{3}'", data.MaPhieuTra, data.MaSach, data.ThanhTien, data.MaCTPT);
openConnection();
int r = ExecuteNonQuery(sql);
if (r > 0)
{
check = true;
}
closeConnection();
return(check);
}
public bool insertData(CTPT data)
{
bool check = false;
String sql = String.Format("INSERT INTO [dbo].[tb_CTPT](maCTPT, maPT, maSach, thanhTien) VALUES('{0}','{1}','{2}','{3}')", data.MaCTPT, data.MaPhieuTra, data.MaSach, data.ThanhTien);
openConnection();
int r = ExecuteNonQuery(sql);
if (r > 0)
{
check = true;
}
closeConnection();
return(check);
}
public bool updateData(CTPT data)
{
return(obj.updateData(data));
}
public bool insertData(CTPT data)
{
return(obj.insertData(data));
}
private void btnTaoPT_Click(object sender, EventArgs e)
{
if (cmbMaDocGia.SelectedIndex < 0)
{
MessageBox.Show("Chọn mã độc giả trước!");
return;
}
if (lstctpt.Count < 1)
{
MessageBox.Show("Dữ liệu trống!");
return;
}
PhieuTra data = new PhieuTra();
string idPT = frm.getIDPT();
data.MaPhieuTra = idPT;
data.MaDocGia = cmbMaDocGia.SelectedValue.ToString();
data.NgayTra = DateTime.Today.ToShortDateString();
data.ThanhTien = 0;
for (int i = 0; i < lstctpt.Count; i++)
{
data.ThanhTien += lstctpt[i].ThanhTien;
}
bool check = false;
check = objpt.insertData(data);
String idPM = "";
List <CTPM> temp = new List <CTPM>();
for (int i = 0; i < lstctpt.Count; i++)
{
CTPT pt = new CTPT();
pt.MaCTPT = frm.getIDCTPT();
MessageBox.Show(pt.MaCTPT);
pt.MaPhieuTra = idPT;
pt.MaSach = lstctpt[i].MaSach;
pt.ThanhTien = lstctpt[i].ThanhTien;
temp = objctpm.getAll("", "maCTPM= '" + lstctpt[i].MaCTPM + "'", "");
idPM = temp[0].MaPM;
temp = objctpm.getAll("", "maPM= '" + idPM + "'", "");
check = objctpt.insertData(pt);
objctpm.deleteData(lstctpt[i].MaCTPM);
if (temp.Count == 1)
{
objpm.deleteData(idPM);
}
}
if (check)
{
MessageBox.Show("Tạo phiếu trả thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (MessageBox.Show("Bạn muốn xuất phiếu trả?", "Thông báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
new frmPTReport(data.MaPhieuTra, data.MaDocGia, data.ThanhTien.ToString()).ShowDialog();
}
}
else
{
MessageBox.Show("Tạo phiếu trả không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Hide();
}
