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));
}
