public void Update(PayableBalance payableBalance) { Transaction tx = null; try { using (var em = EntityManagerFactory.CreateInstance(ds)) { tx = em.BeginTransaction(); //decimal oldGrandTotal = 0; //var oldPayableBalance = GetById(payableBalance.ID); //if (oldPayableBalance != null) //{ // oldGrandTotal = oldPayableBalance.GrandTotal; //} string[] columns = { "BalanceYear", "BalanceMonth", "SalesCode", "SalesDate", "CustomerId", "SalesmanId", "PaymentMethod", "GrandTotal", "IsStatus", "Notes", "AmountInWords", "DueDate", "TermOfPayment", "ModifiedDate" }; object[] values = { payableBalance.BalanceYear, payableBalance.BalanceMonth, payableBalance.SalesCode, payableBalance.SalesDate.ToShortDateString(), payableBalance.CustomerId, payableBalance.SalesmanId, payableBalance.PaymentMethod, payableBalance.GrandTotal, payableBalance.IsStatus == true?1:0, payableBalance.Notes, payableBalance.AmountInWords, payableBalance.DueDate.ToShortDateString(), payableBalance.TermOfPayment, DateTime.Now.ToShortDateString() }; var q = new Query().Select(columns).From(tableName).Update(values).Where("ID").Equal("{" + payableBalance.ID + "}"); em.ExecuteNonQuery(q.ToSql(), tx); payableBalanceItemRepository.Delete(em, tx, payableBalance.ID); foreach (var payableBalanceItem in payableBalance.PayableBalanceItems) { payableBalanceItem.PayableBalanceId = payableBalance.ID; payableBalanceItemRepository.Save(em, tx, payableBalanceItem); } UpdateGrandTotal(em, tx, payableBalance.ID, payableBalance.GrandTotal); //update sales salesRepository.Delete(em, tx, payableBalance.SalesCode); Sales sales = CopyToSales(payableBalance); salesRepository.Save(em, tx, sales); tx.Commit(); } } catch (Exception ex) { tx.Rollback(); throw ex; } }
// GET: SalesItemController1/Delete/5 public ActionResult Delete(int id) { var productDetails = _Salesrepos.FindById(id); var isSucess = _Salesrepos.Delete(productDetails); if (!isSucess) { return(BadRequest()); } return(RedirectToAction(nameof(Index))); }
public async Task <IActionResult> Delete(int id) { try { var customer = await _repository.GetCustomerAsync(id); if (customer == null) { return(NotFound()); } if (await _repository.HasSalesAsync(id)) { return(BadRequest("Cannot delete customers with Sales")); } _repository.Delete(customer); if (await _repository.SaveAllAsync()) { return(Ok()); } } catch (Exception ex) { _logger.LogError("Failed to delete customer", ex); } return(BadRequest("Failed to delete customer, unknown reason")); }
private void tsbDelete_Click(object sender, EventArgs e) { var userAccess = userAccessRepository.GetAll(); bool isAllowed = userAccess.Exists(u => u.FullName == Store.ActiveUser && u.ObjectName == "Penjualan" && u.IsDelete); if (isAllowed == false && Store.IsAdministrator == false) { MessageBox.Show("Anda tidak dapat menghapus", "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (Store.IsPeriodClosed) { MessageBox.Show("Tidak dapat menambah/ubah/hapus \n\n Periode : " + Store.GetMonthName(Store.ActiveMonth) + " " + Store.ActiveYear + "\n\n" + "Sudah Tutup Buku", "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { Sales sales = salesRepository.GetById(new Guid(txtID.Text)); if (sales.Notes.Contains("DIBATALKAN")) { MessageBox.Show("Sudah pernah di hapus ", "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (salesRepository.IsSalesUsedByPayment(new Guid(txtID.Text))) { MessageBox.Show("Tidak bisa menghapus " + "\n\n" + "Dokumen : " + lblCode.Text + "\n\n" + "dipakai di Pelunasan Piutang ", "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (salesRepository.IsSalesUsedByBillReceipt(new Guid(txtID.Text))) { MessageBox.Show("Tidak bisa menghapus " + "\n\n" + "Dokumen : " + lblCode.Text + "\n\n" + "dipakai di TTNT ", "Perhatian", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (MessageBox.Show("Anda yakin ingin menghapus '" + lblCode.Text + "'", "Perhatian", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var sales1 = new Sales(); sales1.ID = new Guid(txtID.Text); sales1.Notes = txtNotes.Text; salesRepository.Delete(sales1); GetLastSales(); } if (lvwSales.Items.Count == 0) { tsbEdit.Enabled = false; tsbDelete.Enabled = false; } } } } }
/// <summary> /// Servicio que elimina una entidad Sales (Sales) dado su Id /// </summary> /// <param name="id">Id de la entidad a eliminar</param> /// <param name="user">Usuario que elimina la entidad</param> public virtual void Delete(int id, string user) { using (var dbContextScope = new TiendaDbContext()) { _repository.Delete(id, user); dbContextScope.SaveChanges(); } }
public async Task Delete(string code) { var sales = await salesRepo.FindByCode(code); if (sales == null) { throw new Exception("Sales not found"); } if (sales.Status != SalesStatus.VALIDATING) { throw new Exception("Sales cannot be deleted"); } await salesRepo.Delete(sales); }
public async Task <bool> Delete(int id) { return(await _salesRepository.Delete(id)); }