public int AddChiTietPhieuTiepNhanBaoHanh(DtoChiTietPhieuTiepNhanBaoHanh dtoCTPTNBH) { try { SqlParameter[] para = { new SqlParameter("@MaCTPTNBH", dtoCTPTNBH.MaCTPTNBH), new SqlParameter("@MaHoaDon", dtoCTPTNBH.MaHoaDon), new SqlParameter("@MaSanPham", dtoCTPTNBH.MaSanPham), new SqlParameter("@MoTaLoi", dtoCTPTNBH.MoTaLoi), new SqlParameter("@SoLuong", dtoCTPTNBH.SoLuong), new SqlParameter("@MaPTNBH", dtoCTPTNBH.MaPTNBH), }; return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure, "sp_InsertCTPTNBH", para); } catch (SqlException) { throw new ArgumentException(Constants.MsgExceptionSql); } catch (Exception) { throw new AggregateException(Constants.MsgExceptionError); } }
public int AddChiTietPhieuTiepNhanBaoHanh(DtoChiTietPhieuTiepNhanBaoHanh dtoCTPTNBH) { return dalCTPTNBH.AddChiTietPhieuTiepNhanBaoHanh(dtoCTPTNBH); }
private void btnLuu_Click(object sender, EventArgs e) { DtoPhieuTiepNhanBaoHanh dtoPTNBH = new DtoPhieuTiepNhanBaoHanh(); List<DtoChiTietPhieuTiepNhanBaoHanh> listCTPTNBH = new List<DtoChiTietPhieuTiepNhanBaoHanh>(); dtoPTNBH.MaPTNBH = txtMaPTNBH.Text; _maPTNBH = txtMaPTNBH.Text; dtoPTNBH.MaNV = txtMaNV.Text.ToString(); dtoPTNBH.NgayLap = DateTime.Now; foreach (DataGridViewRow row in dgvDetailWarranty.Rows) { DtoChiTietPhieuTiepNhanBaoHanh dtoCTPTNBH = new DtoChiTietPhieuTiepNhanBaoHanh(); //dtoCTPTNBH.MaCTPTNBH = int.Parse(dgvCTPTNBH.Rows[i].Cells[0].Value.ToString()); dtoCTPTNBH.MaHoaDon = row.Cells[1].Value.ToString(); dtoCTPTNBH.MaSanPham = row.Cells[2].Value.ToString(); dtoCTPTNBH.MoTaLoi = row.Cells[4].Value.ToString(); dtoCTPTNBH.SoLuong = int.Parse(row.Cells[5].Value.ToString()); dtoCTPTNBH.MaPTNBH = dtoPTNBH.MaPTNBH; listCTPTNBH.Add(dtoCTPTNBH); } if (listCTPTNBH.Count == 0) { DisplayNotify("Không thể tạo phiếu tiếp nhận không có chi tiết", -1); return; } if (bllPTNBH.AddPhieuTiepNhanBaoHanh(dtoPTNBH, listCTPTNBH)) { try { txtMaPTNBH.Text = bllPTNBH.CreatePTNBH(); } catch (Exception ex) { lblThongBao.Text = "Lỗi không tạo mới! mã lỗi " + ex.Message; } btnClear.PerformClick(); txtAboutError.Clear(); MessageBox.Show(Constants.MsgNotificationSuccessfuly); //btnThoat.PerformClick(); } else { MessageBox.Show(Constants.MsgExceptionError); } }