public List <PhieuSuaChuaDTO> GetListPhieuSuaChua() { List <PhieuSuaChuaDTO> phieusuachuaList = new List <PhieuSuaChuaDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from dbo.phieusuachua"); foreach (DataRow item in data.Rows) { PhieuSuaChuaDTO phieusuachua = new PhieuSuaChuaDTO(item); phieusuachuaList.Add(phieusuachua); } return(phieusuachuaList); }
private void btnLapPhieu_Click(object sender, EventArgs e) { if (!fMainForm.cNullTB(cboBienSo.Text) && !fMainForm.cNullTB(txtSoPhieuSuaChua.Text)) { string MaPhieuSuaChua = txtSoPhieuSuaChua.Text.Trim(); string BienSo = cboBienSo.SelectedValue.ToString(); DateTime NgaySuaChua = dtmNgaySuaChua.Value; Decimal _TongTien = int.Parse(txtTongTien.Text); if (!PhieuSuaChuaBUS.checkPK(MaPhieuSuaChua)) { PhieuSuaChuaDTO PhieuSuaChua = new PhieuSuaChuaDTO(MaPhieuSuaChua, BienSo, NgaySuaChua, _TongTien); PhieuSuaChuaBUS.addPhieuSuaChua(PhieuSuaChua); for (int i = 0; i < dgvPhieuSuaChua.Rows.Count - 1; i++) { string NoiDung = dgvPhieuSuaChua.Rows[i].Cells["NoiDung"].Value.ToString(); string MaVatTuPhuTung = dgvPhieuSuaChua.Rows[i].Cells["VatTuPhuTung"].Value.ToString(); int SoLuongSuaChua = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["SoLuong"].Value.ToString()); int TienCong = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["TienCong"].Value.ToString()); Decimal ThanhTien = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["ThanhTien"].Value.ToString()); ChiTietPhieuSuaChuaDTO CTPhieuSuaChua = new ChiTietPhieuSuaChuaDTO(MaPhieuSuaChua, NoiDung, MaVatTuPhuTung, SoLuongSuaChua, TienCong, ThanhTien); ChiTietPhieuSuaChuaBUS.addChiTietPhieuSuaChua(CTPhieuSuaChua); VatTuPhuTungBUS.decreaseSoLuongVatTu(MaVatTuPhuTung, SoLuongSuaChua); } KhachSuaXeDAO.addTienNo(BienSo, _TongTien); dgvLichSuLapPhieu.DataSource = PhieuSuaChuaBUS.selectAllPhieuSuaChua(); #region Clear dgvTable reset = true; rownum = 1; this.dgvPhieuSuaChua.Rows.Clear(); TongTien = 0; txtTongTien.Text = TongTien.ToString(); reset = false; #endregion } else { MessageBox.Show("Dữ liệu vừa nhập vào không hợp lệ, do bị trùng khóa chính."); } } else { MessageBox.Show("Bạn chưa nhập vào đủ dữ liệu xin vui lòng nhập lại."); } }
public static void insertPHIEUSUACHUA(PhieuSuaChuaDTO PhieuSuaChua) { MySqlConnection connect = DatabaseConnectionDAO.connectionDatabase(); MySqlCommand command = new MySqlCommand("InsertPHIEUSUACHUA", connect); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@_MaPhieuSuaChua", MySqlDbType.VarChar, 10); command.Parameters.Add("@_BienSo", MySqlDbType.VarChar, 10); command.Parameters.Add("@_NgaySuaChua", MySqlDbType.Date); command.Parameters.Add("@_TongTien", MySqlDbType.Decimal); command.Parameters["@_MaPhieuSuaChua"].Value = PhieuSuaChua.MaPhieuSuaChua; command.Parameters["@_BienSo"].Value = PhieuSuaChua.BienSo; command.Parameters["@_NgaySuaChua"].Value = PhieuSuaChua.NgaySuaChua; command.Parameters["@_TongTien"].Value = PhieuSuaChua.TongTien; connect.Open(); command.ExecuteNonQuery(); connect.Close(); }
public static void addPhieuSuaChua(PhieuSuaChuaDTO PhieuSuaChua) { PhieuSuaChuaDAO.insertPHIEUSUACHUA(PhieuSuaChua); }