private void toolStripLuu_Click_1(object sender, System.EventArgs e) { var pbh = PhieuBanBLL.SelectTop(int.Parse(comboBoxPhieuBan.Text), 0).FirstOrDefault(); PhieuNo_DTO p = new PhieuNo_DTO() { SoPhieuNo = int.Parse(txtSoPhieuNo.Text), SoPhieuBan = int.Parse(comboBoxPhieuBan.Text), NgayNo = dateTimePickerNgayNo.Value.ToShortDateString(), NgayThanhToan = dateTimePickerNgayThanhToan.Value.ToShortDateString(), SoTienTra = txtSoTienTra.Text == "" ? 0 : decimal.Parse(txtSoTienTra.Text), SoTienConLai = txtConLai.Text == "" ? 0 : decimal.Parse(txtConLai.Text) }; if (Edit == 0) { if (pbh.SoTienTra == pbh.TongTien) { MessageBox.Show("Phiếu bán này đã được trả đủ."); return; } PhieuNoBLL.Insert(p); } if (Edit == 1) { PhieuNoBLL.Insert(p); } if (Edit == 2) { PhieuNoBLL.Update(p); } this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); }
private void toolStripSửa_Click(object sender, EventArgs e) { try { DataGridViewRow r = datagridviewPhieuNo.SelectedRows[0]; PhieuNo_DTO p = new PhieuNo_DTO() { SoPhieuNo = int.Parse(r.Cells["SoPhieuNo"].Value.ToString()), SoPhieuBan = int.Parse(r.Cells["SoPhieuBan"].Value.ToString()), NgayNo = r.Cells["NgayNo"].Value.ToString(), NgayThanhToan = r.Cells["NgayThanhToan"].Value.ToString(), SoTienTra = decimal.Parse(r.Cells["SoTienTra"].Value.ToString()), SoTienConLai = decimal.Parse(r.Cells["SoTienConLai"].Value.ToString()) }; M_PhieuNoEdit form = new M_PhieuNoEdit(p); form.Text = "CHỈNH SỬA THÔNG TIN PHIẾU NỢ"; DialogResult dr = form.ShowDialog(); if (dr == DialogResult.OK) { loadgridview(this.PhieuNo.SelectTop(0)); } } catch (Exception) { //MessageBox.Show(e.ToString() + "\nNếu chưa chọn dòng nào hãy chọn 1 dòng"); } }
public M_PhieuNoEdit(PhieuNo_DTO p) // update { Edit = 2; InitializeComponent(); txtSoPhieuNo.Text = p.SoPhieuNo.ToString(); txtSoPhieuNo.Enabled = false; comboBoxPhieuBan.Text = p.SoPhieuBan.ToString(); comboBoxPhieuBan.Enabled = false; dateTimePickerNgayNo.Text = p.NgayNo; dateTimePickerNgayThanhToan.Text = p.NgayThanhToan; txtSoTienTra.Text = p.SoTienTra.ToString(); txtConLai.Text = p.SoTienConLai.ToString(); }
public void Update(PhieuNo_DTO x) { PHIEUNO phieuno = datacontext.PHIEUNOs.Where(p => p.SoPhieuNo == x.SoPhieuNo).FirstOrDefault(); if (phieuno != null) { phieuno.SoPhieuNo = x.SoPhieuNo; phieuno.SoPhieuBan = x.SoPhieuBan; phieuno.NgayNo = DateTime.Parse(x.NgayNo); phieuno.NgayThanhToan = DateTime.Parse(x.NgayThanhToan); phieuno.SoTienTra = x.SoTienTra; phieuno.SoTienConLai = x.SoTienConLai; } datacontext.SubmitChanges(); }
public void Insert(PhieuNo_DTO x) { PHIEUNO phieuno = new PHIEUNO() { SoPhieuNo = x.SoPhieuNo, SoPhieuBan = x.SoPhieuBan, NgayNo = DateTime.Parse(x.NgayNo), NgayThanhToan = DateTime.Parse(x.NgayThanhToan), SoTienTra = x.SoTienTra, SoTienConLai = x.SoTienConLai }; datacontext.PHIEUNOs.InsertOnSubmit(phieuno); datacontext.SubmitChanges(); }