/// <summary>
/// Actualiza el total
/// </summary>
public int UpdateTotal(string pStrCode)
{
int lIntResult = -1;
try
{
PurchasesServiceFactory mObjPurchaseServiceFactory = new PurchasesServiceFactory();
var lObjVoucher = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetVouches(pStrCode);
if (lObjVoucher.Count > 0)
{
List <VouchersDetailDTO> lLstVouchersDetail = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetInvoiceVouchesDetail(lObjVoucher[0].Area, lObjVoucher[0].Folio);
lObjVoucher[0].Total = lLstVouchersDetail.Where(x => x.Status != "Cancelado").Sum(x => x.Total);
// lObjVoucher[0].Total = pDblTotal;
// lObjVoucher[0].Total = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetVouchesDetail(pStrCode).Where(x => x.Status != "Cancelado").Sum(x => x.Total);
lIntResult = mObjPurchaseServiceFactory.GetVouchersService().Update(lObjVoucher[0]);
if (lIntResult != 0)
{
UIApplication.ShowMessageBox(string.Format("Exception: {0}", DIApplication.Company.GetLastErrorDescription()));
LogService.WriteError("InvoiceDI (AddVoucherDetail) " + DIApplication.Company.GetLastErrorDescription());
}
}
else
{
LogService.WriteError("VouchersService: Comprobante no encontrado: " + pStrCode);
}
}
catch (System.Exception ex)
{
LogService.WriteError("VouchersService (UpdateTotal) " + ex.Message);
LogService.WriteError(ex);
}
return(lIntResult);
}
//Actualiza status de comprobante
private bool UpdateCancel(string pStrDocEntry, string pStrCodeVoucher)
{
bool lBolResult = false;
try
{
List <VouchersDetail> lLstVouchersDetail = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetVoucherDetailByTrans(pStrDocEntry);
if (lLstVouchersDetail.Count > 0)
{
VouchersDetail lObjVoucherDetail = lLstVouchersDetail.Where(x => x.DocEntry == pStrDocEntry).FirstOrDefault();
lObjVoucherDetail.Status = "Cancelado";
if (mObjPurchaseServiceFactory.GetVouchersDetailService().Update(lObjVoucherDetail) == 0)
{
mObjPurchaseServiceFactory.GetVouchersService().UpdateTotal(pStrCodeVoucher);
lBolResult = true;
LogService.WriteSuccess("PolicyDI (UpdateCancel) Cancelacion realizada correctamente, TransId: " + pStrDocEntry);
}
else
{
lBolResult = false;
LogService.WriteError("PolicyDI (UpdateCancel) TransId:" + pStrDocEntry + " Mensaje:" + DIApplication.Company.GetLastErrorDescription());
}
}
}
catch (Exception ex)
{
LogService.WriteError("PolicyDI (UpdateCancel) TransId:" + pStrDocEntry + " Mensaje:" + ex.Message);
LogService.WriteError(ex);
}
return(lBolResult);
}
/// <summary>
/// Actualiza estatus
/// </summary>
public void UpdateStatus(string pStrCode, string pStrDocEntry, string pStrCodeVoucher)
{
try
{
VouchersDetail lObjVoucher = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetVouchesDetail(pStrCode).Where(x => x.DocEntry == pStrDocEntry).First();
if (!string.IsNullOrEmpty(lObjVoucher.DocEntry))
{
string lStrDocStatus = mObjPurchaseServiceFactory.GetPurchaseInvoiceService().GetDocCanceled(pStrDocEntry, lObjVoucher.Type);
if (!lStrDocStatus.Equals("Cancelado"))
{
lStrDocStatus = mObjPurchaseServiceFactory.GetPurchaseInvoiceService().GetDocStatus(pStrDocEntry);
}
lObjVoucher.Status = lStrDocStatus;
if (mObjPurchaseServiceFactory.GetVouchersDetailService().Update(lObjVoucher) != 0)
{
UIApplication.ShowMessageBox(string.Format("Exception: {0}", DIApplication.Company.GetLastErrorDescription()));
LogService.WriteError("InvoiceDI (AddVoucherDetail) " + DIApplication.Company.GetLastErrorDescription());
}
else
{
mObjPurchaseServiceFactory.GetVouchersService().UpdateTotal(pStrCodeVoucher);
}
}
}
catch (Exception ex)
{
LogService.WriteError("InvoiceDI (UpdateStatus) " + ex.Message);
LogService.WriteError(ex);
}
}
private void LoadCombobxBank()
{
int lIntValuesLength = cbBank.ValidValues.Count - 1;
for (int i = 0; i < lIntValuesLength + 1; i++)
{
cbBank.ValidValues.Remove(0, SAPbouiCOM.BoSearchKey.psk_Index);
}
IList <BankDTO> lLstObjBanks = mObjPurchasesServiceFactory.GetPurchaseVouchersService().GetBankList();
cbBank.ValidValues.Add("", "");
foreach (BankDTO lObjBank in lLstObjBanks)
{
cbBank.ValidValues.Add(lObjBank.BankCode, lObjBank.BankName);
}
}
private void Search()
{
try
{
SearchVouchersDTO lObjSearchVouchers = new SearchVouchersDTO();
lObjSearchVouchers.Area = txtArea.Value;
if (string.IsNullOrEmpty(txtEmploye.Value))
{
mStrEmployeId = "";
}
if (string.IsNullOrEmpty(cboStatus.Value))
{
lObjSearchVouchers.Status = 0;
}
else
{
lObjSearchVouchers.Status = Convert.ToInt32(cboStatus.Value);
}
lObjSearchVouchers.Employee = mStrEmployeId;
lObjSearchVouchers.StartDate = txtStartD.Value;
lObjSearchVouchers.EndDate = txtEndDate.Value;
List <Vouchers> lLstVouchers = new List <Vouchers>();
lLstVouchers = mObjPurchasesServiceFactory.GetPurchaseVouchersService().GetVouchersList(lObjSearchVouchers).ToList();
if (DtMatrix == null)
{
CreateDataTableMatrix();
}
else
{
DtMatrix.Rows.Clear();
}
FillMatrix(lLstVouchers);
}
catch (Exception ex)
{
UIApplication.ShowMessageBox(ex.Message);
LogService.WriteError("frmSearchRefunds (btnSearch_ClickBefore) " + ex.Message);
LogService.WriteError(ex);
}
}
public int Update(string pStrCode, StatusEnum pEnumStatus)
{
PurchasesServiceFactory mObjPurchaseServiceFactory = new PurchasesServiceFactory();
var lObjVoucher = mObjPurchaseServiceFactory.GetPurchaseVouchersService().GetVouches(pStrCode);
if (lObjVoucher.Count > 0)
{
lObjVoucher[0].Status = (int)pEnumStatus;
return(mObjVouchersDAO.Update(lObjVoucher[0]));
}
return(-1);
}
