private void btnLuuLai_Click(object sender, EventArgs e) { try { int soLuongXuat = int.Parse(txtSoLuongXuat.Text); idPhieuNhap = GoodsDeliveryNoteBus.Instance.getGoodsDeliveryNoteByDate(); if (idPhieuNhap == 0) { int id_employee = 1; GoodsDeliveryNoteBus.Instance.InsertDeliveryNote(id_employee); } idPhieuNhap = GoodsDeliveryNoteBus.Instance.getGoodsDeliveryNoteByDate(); DeliveryNoteDetail deliveryNoteDetail = new DeliveryNoteDetail( idPhieuNhap, id_product, soLuongXuat ); DeliveryNoteDetailBus.Instance.InsertDeliveryNoteDetail(deliveryNoteDetail); XtraMessageBox.Show("Cập nhật sản phẩm thành công!", "Cập nhật sản phẩm"); } catch (Exception ex) { XtraMessageBox.Show("Error: " + ex); } loadPhieuXuatTheoNgay(); resetInput(); }
public bool InsertDeliveryNoteDetail(DeliveryNoteDetail deliveryNoteDetail) { try { return(ProccessDeliveryNoteDetail.Instance.InsertDeliveryNodeDetail(deliveryNoteDetail)); } catch (Exception ex) { throw ex; } }
public bool InsertDeliveryNodeDetail(DeliveryNoteDetail deliveryNoteDetail) { string query = string.Format("SP_Insert_DeliveryNoteDetail @Id_GoodsDeliveryNote , @Id_product , @Amount"); int result; try { result = DataProvider.Instance.ExecuteNonQuery(query, new object[] { deliveryNoteDetail.Id_goodsDeliverNote, deliveryNoteDetail.Id_product, deliveryNoteDetail.Amount }); } catch (Exception ex) { throw ex; } return(result > 0); }