public int Update(Phieu_Nhap_Kho nk) { DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); int temp = 0; using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { using (var context = help.ent) { context.Phieu_Nhap_Kho.Attach(nk); context.Entry(nk).State = EntityState.Modified; temp = help.ent.SaveChanges(); dbcxtransaction.Commit(); } // dbcxtransaction.Commit(); } return temp; }
private void btnLuu_Click(object sender, EventArgs e) { if (txtMaPhieuNhap.Text.Trim() == "") { MessageBox.Show("Mã phiếu bắt buộc nhập!"); return; } if (cbKhoNhan.Text == "" ) { MessageBox.Show("Chưa nhập kho hoặc mã phiếu"); return; } DatabaseHelper help = new DatabaseHelper(); help.ConnectDatabase(); //switch (staTus) switch (PanelButton.getClickStatus()) { #region "Thêm" case enumButton2.Them: using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { try { clsPhieuNhapKho phieunhap = new clsPhieuNhapKho(); phieunhap.Ma_phieu_nhap = txtMaPhieuNhap.Text; if (!phieunhap.CheckTonTaiSoDK(txtMaPhieuNhap.Text)) { phieunhap.Kho_nhan = cbKhoNhan.Text; phieunhap.Kho_xuat_ra = txtXuatTaiKho.Text; phieunhap.Da_phan_kho = false; phieunhap.ID_Loai_Phieu_Nhap = null; phieunhap.Ma_phieu_nhap = txtMaPhieuNhap.Text; phieunhap.Dia_chi = txtDiaChi.Text; phieunhap.Ly_do = txtLyDo.Text; phieunhap.Ngay_lap = dtNgayNhap.Value; phieunhap.Cong_trinh = txtCongTrinh.Text; phieunhap.Da_phan_kho = false; phieunhap.ID_khoNhan = (int)cbKhoNhan.SelectedValue; if (rdoKNMN.Checked == true) phieunhap.isKNMN = true; if (rdoKNTN.Checked == true) phieunhap.isKNTN = true; if (rdoKCTN.Checked == true) phieunhap.isKCTN = true; if (rdoKCMuonNo.Checked == true) phieunhap.isKCMN = true; phieunhap.isNhapNgoai = true; phieunhap.Ten_kho_muon = cbKhoNgoai.Text; if (phieunhap.Insert(help) == 1) { //DataTable chiTietPhieuNhap = new clsChi_Tiet_Phieu_Nhap_Vat_Tu().GetAll(phieuNhap.ID_phieu_nhap); for (int i = 0; i < dataTable1.Rows.Count; i++) { clsChi_Tiet_Phieu_Nhap_Vat_Tu chitiet = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); // chitiet.ID_chi_tiet_phieu_nhap = int.Parse(gridMaster.Rows[i].Cells["ID_chi_tiet_phieu_nhap"].ToString()); chitiet.Ma_phieu_nhap = (txtMaPhieuNhap.Text); chitiet.ID_Don_vi_tinh = int.Parse(dataTable1.Rows[i]["ID_Don_vi_tinh"].ToString()); chitiet.Ma_vat_tu = (dataTable1.Rows[i]["Ma_vat_tu"].ToString()); chitiet.ID_Chat_luong = int.Parse(dataTable1.Rows[i]["ID_Chat_luong"].ToString()); // chitiet.So_luong_yeu_cau = decimal.Parse(dataTable1.Rows[i]["So_luong_yeu_cau"].ToString()); chitiet.So_luong_thuc_lanh = decimal.Parse(dataTable1.Rows[i]["so_luong_thuc_lanh"].ToString()); chitiet.Don_gia = decimal.Parse(dataTable1.Rows[i]["Don_gia"].ToString()); chitiet.Thanh_tien = decimal.Parse(dataTable1.Rows[i]["Thanh_tien"].ToString()); chitiet.Da_duyet = false; if (chitiet.Insert(help) == 0) dbcxtransaction.Rollback(); } dbcxtransaction.Commit(); PanelButton.ResetClickStatus(); //setInputComponentStatus(true); enableInputForm(); PanelButton.ResetButton(); frmDanhSachPhieuNhap dspn = new frmDanhSachPhieuNhap(txtMaPhieuNhap.Text); dspn.Show(); } else dbcxtransaction.Rollback(); } else { MessageBox.Show("mã phiếu nhập này đã tồn tại trong csdl!"); button2_Click(this, EventArgs.Empty); } } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); dbcxtransaction.Rollback(); } } break; #endregion #region "Sua" case enumButton2.Sua: { using (var dbcxtransaction = help.ent.Database.BeginTransaction()) { try { clsPhieuNhapKho phieunhap = new clsPhieuNhapKho(); phieunhap.Ma_phieu_nhap = txtMaPhieuNhap.Text; { // phieunhap. // phieunhap.ID_Loai_Phieu_Nhap = Int32.Parse(cbLoaiPhieuNhan.SelectedValue.ToString()); phieunhap.Ma_phieu_nhap = txtMaPhieuNhap.Text; phieunhap.Dia_chi = txtDiaChi.Text; phieunhap.Ly_do = txtLyDo.Text; phieunhap.Ngay_lap = dtNgayNhap.Value; // phieunhap.So_hoa_don = txtSoHD.Text; phieunhap.Cong_trinh = txtCongTrinh.Text; //if (rdoKNMN.Checked == true) // phieunhap.isChoMuonNgoai = true; if (rdoKNMN.Checked == true) phieunhap.isKNMN = true; if (rdoKNTN.Checked == true) phieunhap.isKNTN = true; if (rdoKCTN.Checked == true) phieunhap.isKCTN = true; if (rdoKCMuonNo.Checked == true) phieunhap.isKCMN = true; phieunhap.isNhapNgoai = true; //if (isLoaiPhieu == "TN") // phieunhap.isTraNo = true; // phieunhap.isGoiDau = chbNGD.Checked; phieunhap.ID_khoNhan = (int)cbKhoNhan.SelectedValue; DataTable temp = phieunhap.GetThongTinPhieuMuonNo(phieunhap.Ma_phieu_nhap); Phieu_Nhap_Kho nk = new Phieu_Nhap_Kho(); nk.Ma_phieu_nhap = phieunhap.Ma_phieu_nhap; nk.ID_phieu_nhap = int.Parse(temp.Rows[0]["ID_phieu_nhap"].ToString()); nk.Cong_trinh = phieunhap.Cong_trinh; nk.Da_phan_kho = phieunhap.Da_phan_kho; nk.Dia_Chi = phieunhap.Dia_chi; nk.ID_Loai_Phieu_Nhap = phieunhap.ID_Loai_Phieu_Nhap; nk.Kho_nhan = phieunhap.Kho_nhan; nk.ID_kho = phieunhap.ID_khoNhan; nk.Kho_xuat_ra = phieunhap.Kho_xuat_ra; // nk.isKNTN = phieunhap.isTraNo; nk.isToTrinh = phieunhap.isToTrinh; nk.Ly_do = phieunhap.Ly_do; nk.Ngay_lap = phieunhap.Ngay_lap; nk.So_hoa_don = phieunhap.So_hoa_don; nk.isKNMN = phieunhap.isKNMN; nk.isKNTN = phieunhap.isKNTN; nk.isKCTN = phieunhap.isKCTN; nk.isKCMN = phieunhap.isKCMN; nk.isNVMN = phieunhap.isNVMN; nk.isNhapNgoai = true; if (phieunhap.Update(nk) == 1) { clsChi_Tiet_Phieu_Nhap_Vat_Tu pn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); pn.Ma_phieu_nhap = phieunhap.Ma_phieu_nhap; pn.remove(pn.Ma_phieu_nhap); for (int i = 0; i < dataTable1.Rows.Count; i++) { clsChi_Tiet_Phieu_Nhap_Vat_Tu chitiet = new clsChi_Tiet_Phieu_Nhap_Vat_Tu(); chitiet.Ma_phieu_nhap = (txtMaPhieuNhap.Text); chitiet.ID_Don_vi_tinh = int.Parse(dataTable1.Rows[i]["ID_Don_vi_tinh"].ToString()); chitiet.Ma_vat_tu = (dataTable1.Rows[i]["Ma_vat_tu"].ToString()); chitiet.ID_Chat_luong = int.Parse(dataTable1.Rows[i]["ID_Chat_luong"].ToString()); chitiet.So_luong_thuc_lanh = decimal.Parse(dataTable1.Rows[i]["so_luong_thuc_lanh"].ToString()); chitiet.Don_gia = decimal.Parse(dataTable1.Rows[i]["Don_gia"].ToString()); chitiet.Thanh_tien = decimal.Parse(dataTable1.Rows[i]["Thanh_tien"].ToString()); chitiet.Da_duyet = false; chitiet.ID_Chat_luong = int.Parse(cbChatLuong.SelectedValue.ToString()); if (chitiet.Insert(help) == 0) dbcxtransaction.Rollback(); } dbcxtransaction.Commit(); PanelButton.ResetClickStatus(); //setInputComponentStatus(true); enableInputForm(); PanelButton.ResetButton(); } else dbcxtransaction.Rollback(); } } catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); dbcxtransaction.Rollback(); } } this.ds.LoadData(); break; } #endregion } }
//dal.BeginTransaction(); //m_dbConnection = dal.m_conn; //if(m_dbConnection.State == ConnectionState.Closed) // m_dbConnection.Open(); //string sql = ""; //sql += "INSERT INTO Phieu_Nhap_Kho (ma_phieu_nhap,ID_kho,Ngay_lap,ly_do,Dia_chi,Cong_trinh) "; //sql += "VALUES(@ma_phieu_nhap,@ID_kho,@Ngay_lap,@ly_do,@Dia_chi,@Cong_trinh)"; //SqlCommand command = new SqlCommand(sql, m_dbConnection,dal.m_trans); //command.CommandType = CommandType.Text; ////command.Parameters.Add(new SQLiteParameter("@BangKe_Id", BangKe_Id)); //command.Parameters.Add(new SqlParameter("@ma_phieu_nhap", Ma_phieu_nhap)); //command.Parameters.Add(new SqlParameter("@ID_kho", ID_kho)); //command.Parameters.Add(new SqlParameter("@Ngay_lap", Ngay_lap.ToString("yyyy-MM-dd"))); //command.Parameters.Add(new SqlParameter("@Ly_do", Ly_do)); //// command.Parameters.Add(new SqlParameter("@So_hoa_don", So_hoa_don)); //command.Parameters.Add(new SqlParameter("@Dia_chi", Dia_chi)); //command.Parameters.Add(new SqlParameter("@Cong_trinh", Cong_trinh)); ////command.Parameters.Add(new SqlParameter("@ma_phieu_nhap", Ma_phieu_nhap)); //int result = command.ExecuteNonQuery(); //dal.CommitTransaction(); public int Update( DatabaseHelper help,Phieu_Nhap_Kho nk) { int temp = 0; { { help.ent.Phieu_Nhap_Kho.Attach(nk); help.ent.Entry(nk).State = EntityState.Modified; temp = help.ent.SaveChanges(); } // dbcxtransaction.Commit(); } return temp; }