public static void insertChiTietPhieuChuaChua(ChiTietPhieuSuaChuaDTO ChiTiet)
{
MySqlConnection connection = DatabaseConnectionDAO.connectionDatabase();
MySqlCommand command = new MySqlCommand("InsertCHITIETPHIEUSUACHUA", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@_MaPhieuSuaChua", MySqlDbType.VarChar, 10);
command.Parameters.Add("@_NoiDung", MySqlDbType.VarChar, 100);
command.Parameters.Add("@_MaVatTuPhuTung", MySqlDbType.VarChar, 10);
command.Parameters.Add("@_SoLuongSuaChua", MySqlDbType.Int16);
command.Parameters.Add("@_TienCong", MySqlDbType.Decimal);
command.Parameters.Add("@_ThanhTien", MySqlDbType.Decimal);
command.Parameters["@_MaPhieuSuaChua"].Value = ChiTiet.MaPhieuSuaChua;
command.Parameters["@_NoiDung"].Value = ChiTiet.NoiDung;
command.Parameters["@_MaVatTuPhuTung"].Value = ChiTiet.MaVatTuPhuTung;
command.Parameters["@_SoLuongSuaChua"].Value = ChiTiet.SoLuongSuaChua;
command.Parameters["@_TienCong"].Value = ChiTiet.TienCong;
command.Parameters["@_ThanhTien"].Value = ChiTiet.ThanhTien;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
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 addChiTietPhieuSuaChua(ChiTietPhieuSuaChuaDTO ChiTiet)
{
ChiTietPhieuSuaChuaDAO.insertChiTietPhieuChuaChua(ChiTiet);
}
