public CheckNotebook(Cheque.BL.CheckClass check)
: base(Gtk.WindowType.Toplevel)
{
this.Build ();
notebook1.PrevPage ();
checkinfo.UpdateInfo (check);
checkinfo.ChangedCheck += (object sender, EventArgs e) => {
customerinfo1.customer = DAL.DataManager.GetCustomer (check.CustomerID);
customerinfo1.UpdateInfo ();
customerinfo1.ShowAll ();
branchinfo1.Branch = DAL.DataManager.GetBranch (check.BranchNumber, check.BankNumber);
branchinfo1.UpdateInfo ();
branchinfo1.ShowAll ();
};
checkinfo.ShowAll ();
customerinfo1.customer = DAL.DataManager.GetCustomer (check.CustomerID);
customerinfo1.UpdateInfo ();
customerinfo1.ShowAll ();
branchinfo1.Bank = DAL.DataManager.GetBank (check.BankNumber);
branchinfo1.Branch = DAL.DataManager.GetBranch (check.BranchNumber, check.BankNumber);
branchinfo1.UpdateInfo ();
branchinfo1.ShowAll ();
}
public void Alterar(Cheque cheque)
{
try
{
Cheque chequeAux = new Cheque();
chequeAux.ID = cheque.ID;
List<Cheque> resultado = this.Consultar(chequeAux, TipoPesquisa.E);
if (resultado == null || resultado.Count == 0)
throw new ChequeNaoAlteradoExcecao();
chequeAux.Agencia = cheque.Agencia;
chequeAux.Banco = cheque.Banco;
chequeAux.Conta = cheque.Conta;
chequeAux.Cpf = cheque.Cpf;
chequeAux.NumCheque = cheque.NumCheque;
chequeAux.Parcela = cheque.Parcela;
chequeAux.Status = cheque.Status;
chequeAux.Tipo = cheque.Tipo;
chequeAux.Valor = cheque.Valor;
chequeAux = resultado[0];
Confirmar();
}
catch (Exception)
{
throw new ChequeNaoAlteradoExcecao();
}
}
private void Valider_Click(object sender, RoutedEventArgs e)
{
double som;
string s = somme.Text.ToString();
string cinC = cinClient.Text.ToString();
string numC = numCheque.Text.ToString();
if (somme.Text.ToString() == "" || numCheque.Text.ToString() == "" || nomClient.Text.ToString() == "" || cinClient.Text.ToString() == "")
{
MessageBox.Show("Les champs sant obligatoire !");
}
else if (!double.TryParse(s, out som))
{
MessageBox.Show("Montant doit etre un reel !");
}
else if (!double.TryParse(cinC, out som))
{
MessageBox.Show("CIN doit etre un entier !");
}
else if (!double.TryParse(numC, out som))
{
MessageBox.Show("Numéro du compte doit etre un entier !");
}
else if (nomClient.Text == "")
{
MessageBox.Show("Nom et prénom incorect !");
}
decimal sum;
decimal.TryParse(somme.Text, out sum);
if (prix == sum)
{
TK_et_FK tk = new TK_et_FK(com);
tk.ShowDialog();
CommandeDAO daoc = new CommandeDAO();
daoc.updateEtat(com);
decimal some;
DateTime d;
ChequeDAO daoch = new ChequeDAO();
DateTime.TryParse(dateCheque.Text, out d);
Decimal.TryParse(somme.Text, out some);
int lastch = daoch.getLastCheque() + 1;
Cheque cheque = new Cheque(some, d, nomClient.Text, cinClient.Text, numCheque.Text);
daoch.add(cheque);
Payement pa = new Payement(1, lastch, com, sum);
PayementDAO daop = new PayementDAO();
daop.addPaycheque(pa);
g.PerformRefresh();
TableDAO table = new TableDAO();
Commande c = daoc.getById(com);
table.update(c.NumTable, false);
this.Close();
p.Close();
}
else
{
decimal res = prix - sum;
this.p.txtEspece.Text = "" + res;
this.p.lbltotal.Content = "" + res;
decimal some;
DateTime d;
ChequeDAO daoch = new ChequeDAO();
DateTime.TryParse(dateCheque.Text, out d);
Decimal.TryParse(somme.Text, out some);
int lastch = daoch.getLastCheque() + 1;
Cheque cheque = new Cheque(some, d, nomClient.Text, cinClient.Text, numCheque.Text);
daoch.add(cheque);
Payement pa = new Payement(1, lastch, com, sum);
PayementDAO daop = new PayementDAO();
daop.addPaycheque(pa);
g.PerformRefresh();
this.Close();
}
}
public ActionResult pagoEnvio2(Pago model, string clienteR, MetodoPago e, Cheque ch, Transferencia trans, Tarjeta tarj)
{
//DAOPago data = DAOPago.getInstance();
//data.insertarPago(model2.monto, model.fecha, pagoD, model2.cod);
int fkCliente = Int32.Parse(clienteR);
int pagoTotal = e.montoE + ch.montoCh + trans.montoTrans + tarj.montoTarj;
int montoTotal = model.montoTotal;
string metodoPago = TempData["metodo1"].ToString();
string metodoPago2 = TempData["metodo2"].ToString();
string metodoPago3 = TempData["metodo3"].ToString();
string metodoPago4 = TempData["metodo4"].ToString();
if (pagoTotal == montoTotal)
{
DAOPago data2 = DAOPago.getInstance();
Pago pago = data2.buscarUltimoPago();
if ((metodoPago == "efectivo") || (metodoPago2 == "efectivo") || (metodoPago3 == "efectivo") || (metodoPago4 == "efectivo"))
{
DAOEfectivo dataE = DAOEfectivo.getInstance();
dataE.insertarEfectivo(pago.cod, e.moneda, fkCliente);
}
if ((metodoPago == "cheque") || (metodoPago2 == "cheque") || (metodoPago3 == "cheque") || (metodoPago4 == "cheque"))
{
DAOCheque dataCh = DAOCheque.getInstance();
dataCh.insertarCheque(pago.cod, ch.Banco, ch.NroCuenta, ch.fecha, ch.montoCh, fkCliente);
}
if ((metodoPago == "transferencia") || (metodoPago2 == "transferencia") || (metodoPago3 == "transferencia") || (metodoPago4 == "transferencia"))
{
DAOTransferencia dataTrans = DAOTransferencia.getInstance();
dataTrans.insertarTransferencia(pago.cod, trans.Banco, trans.NroCuenta, trans.descripcion, trans.correo, fkCliente);
}
if ((metodoPago == "tarjeta") || (metodoPago2 == "tarjeta") || (metodoPago3 == "tarjeta") || (metodoPago4 == "tarjeta"))
{
DAOTarjeta dataTarj = DAOTarjeta.getInstance();
dataTarj.insertarTarjeta(pago.cod, tarj.Banco, tarj.NroCuenta, tarj.tipo, tarj.fechaVencimiento, tarj.marca, fkCliente);
}
DAOEnvio data = DAOEnvio.getInstance();
List <Envio> envios = data.obtenerEnvio();
foreach (var item in envios)
{
data2 = DAOPago.getInstance();
pago = data2.buscarPagoEnvio(item.cod);
item.codPago = pago.cod;
}
return(View("~/Views/EnviarPaquete/IndexEnvio.cshtml", envios));
}
else
{
DAOPago data2 = DAOPago.getInstance();
Pago pago = data2.buscarUltimoPago();
//DAOEfectivo dataE = DAOEfectivo.getInstance();
//dataE.insertarEfectivo(pago.cod, e.moneda, c.CI);
//DAOCheque dataCh = DAOCheque.getInstance();
//dataCh.insertarCheque(pago.cod, ch.Banco, ch.NroCuenta, ch.fecha, ch.montoCh, c.CI);
//DAOTransferencia dataTrans = DAOTransferencia.getInstance();
//dataTrans.insertarTransferencia(pago.cod, trans.Banco, trans.NroCuenta, trans.descripcion, trans.correo, c.CI);
//DAOTarjeta dataTarj = DAOTarjeta.getInstance();
//dataTarj.insertarTarjeta(pago.cod, tarj.Banco, tarj.NroCuenta, tarj.tipo, tarj.fechaVencimiento, tarj.marca, c.CI);
ViewBag.mP = metodoPago;
ViewBag.mP2 = metodoPago2;
ViewBag.mP3 = metodoPago3;
ViewBag.mP4 = metodoPago4;
ViewBag.Error = "LA SUMA DE LOS PAGOS NO ES SUFICIENTE";
return(View("~/Views/Pago/PagoEnvio2.cshtml", pago));
}
}
public async Task <HttpResponseMessage> LoadReceiveAndPay([FromBody] int id)
{
var organId = Convert.ToInt32(SecurityManager.CurrentUserContext.OrganizationId);
FinanYearRule finanYearRule = new FinanYearRule();
var finanYerar = await finanYearRule.GetCurrentFinanYear(organId);
var payRecevie = await Rule.FindAsync(id);
ReceiveAndPayVM receiveAndPayVM = new ReceiveAndPayVM();
//var account = await accountRule.FindAsync((int)payRecevie.AccountId);
//receiveAndPayVM.Account = account;
receiveAndPayVM.Amount = payRecevie.Amount;
receiveAndPayVM.Contact = payRecevie.Contact;
receiveAndPayVM.Description = payRecevie.Description;
//receiveAndPayVM.DetailAccount = payRecevie.de
receiveAndPayVM.DisplayDate = payRecevie.DisplayDate;
receiveAndPayVM.Id = payRecevie.ID;
receiveAndPayVM.Invoice = payRecevie.Invoice;
receiveAndPayVM.Items = payRecevie.Items.ToList();
receiveAndPayVM.Number = payRecevie.Document.Number;
receiveAndPayVM.Number2 = payRecevie.Document.Number2;
//receiveAndPayVM.PayItems = payRecevie.pa
receiveAndPayVM.Type = payRecevie.Type;
if (payRecevie.Contact != null)
{
payRecevie.ContactId = payRecevie.Contact.ID;
}
if (payRecevie.Invoice != null)
{
payRecevie.InvoiceId = payRecevie.Invoice.ID;
}
decimal amount = 0;
foreach (var item in payRecevie.Items)
{
amount += item.Amount;
if (item.CashId > 0)
{
CashRule cashRule = new CashRule();
item.Cash = await cashRule.FindAsync((int)item.CashId);
}
else if (item.Bank != null)
{
item.BankId = item.Bank.ID;
}
else if (item.Cheque != null)
{
Cheque cheque = new Cheque()
{
Amount = item.Amount,
BankBranch = item.Cheque.BankBranch,
BankName = item.Cheque.BankName,
ChequeNumber = item.Cheque.ChequeNumber,
Contact = payRecevie.Contact,
ContactId = payRecevie.Contact.ID,
Date = DateTime.Now,// item.Cheque.Date,
OrganId = organId,
Status = ZhivarEnums.ChequeStatus.Normal,
DisplayDate = item.Cheque.DisplayDate,
Type = ZhivarEnums.ChequeType.Pardakhtani,
ReceiptDate = DateTime.Now,
};
item.Cheque = cheque;
item.ChequeId = item.Cheque.ID;
}
}
payRecevie.Amount = amount;
if (payRecevie.Contact != null)
{
var account1104 = await CalcAccountByCodeTafziliAsync(organId, "1104" + payRecevie.Contact.Code);
var account1105 = await CalcAccountByCodeTafziliAsync(organId, "1105" + payRecevie.Contact.Code);
var account2101 = await CalcAccountByCodeTafziliAsync(organId, "2101" + payRecevie.Contact.Code);
payRecevie.Contact.Balance = account1104.sumTotal + account1105.sumTotal + account2101.sumTotal - amount;
payRecevie.Contact.Credits = account1104.sumCredit + account1105.sumCredit + account2101.sumCredit - amount;
payRecevie.Contact.Liability = account1104.sumDebit + account1105.sumDebit + account2101.sumDebit;
}
//if (payRecevie.Invoice != null)
//{
// if (payRecevie.Invoice.Contact != null)
// payRecevie.Invoice.ContactId = payRecevie.Invoice.Contact.ID;
// //payRecevie.Invoice.FinanYear = finanYerar;
// //payRecevie.Invoice.FinanYearId = finanYerar.ID;
// var invoice = payRecevie.Invoice;
// invoice.Rest -= amount;
// invoice.Paid += amount;
// invoiceRule.Update(invoice);
//}
return(Request.CreateResponse(HttpStatusCode.OK, new { resultCode = (int)ZhivarEnums.ResultCode.Successful, data = payRecevie }));
}
///<inheritdoc cref="IChequeService"/>
public async Task <Cheque> SaveCheque(Cheque cheque)
{
Log.Info("Received a request to save the receipt");
return(await Repository.Insert(cheque));
}
public abstract void Sustar(Cheque cheque, DateTime dataEvento, string motivo);
public override void Compensar(Cheque cheque, DateTime dataEvento)
{
cheque.MudarEstado(new ChequeCompensado(dataEvento));
}
public ClientResponse listarReporte(int CampaniaID, int ProductoID, int InstitucionEducativaID, DateTime?FechaInicial, DateTime?FechaFinal, int paginaActual, int RegistroXPagina)
{
int recordCount = 0;
try
{
using (conexion = new SqlConnection(ConexionDAO.cnx))
{
using (comando = new SqlCommand("usp_cheque_getLst", conexion))
{
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@CampaniaID", CampaniaID);
comando.Parameters.AddWithValue("@ProductoID", ProductoID);
comando.Parameters.AddWithValue("@InstitucionEducativaID", InstitucionEducativaID);
comando.Parameters.AddWithValue("@StartDate", FechaInicial);
comando.Parameters.AddWithValue("@EndDate", FechaFinal);
comando.Parameters.AddWithValue("@vi_Pagina", paginaActual);
comando.Parameters.AddWithValue("@vi_RegistrosporPagina", RegistroXPagina);
comando.Parameters.Add("@vi_RecordCount", SqlDbType.Int).Direction = ParameterDirection.Output;
conexion.Open();
using (reader = comando.ExecuteReader())
{
while (reader.Read())
{
entidad = new Cheque();
entidad.ID = (reader["ID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"].ToString());
entidad.CampaniaID = (reader["CampaniaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["CampaniaID"]);
Campania oCamp = new Campania();
oCamp.Nombre = (reader["CampaniaNm"] == DBNull.Value) ? "" : reader["CampaniaNm"].ToString();
entidad.Campania = oCamp;
entidad.InstitucionEducativaID = (reader["InstitucionEducativaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["InstitucionEducativaID"]);
InstitucionEducativa oInst = new InstitucionEducativa();
oInst.Nombre = (reader["InstitucionEducativaNm"] == DBNull.Value) ? "" : reader["InstitucionEducativaNm"].ToString();
entidad.InstitucionEducativa = oInst;
entidad.CIASeguroID = (reader["CIASeguroID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["CIASeguroID"]);
CIASeguro oCia = new CIASeguro();
oCia.Nombre = (reader["CIASeguroNm"] == DBNull.Value) ? "" : reader["CIASeguroNm"].ToString();
entidad.CIASeguro = oCia;
entidad.ProductoID = (reader["ProductoID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["ProductoID"]);
Producto oProd = new Producto();
oProd.Nombre = (reader["ProductoNm"] == DBNull.Value) ? "" : reader["ProductoNm"].ToString();
entidad.Producto = oProd;
entidad.BancoID = (reader["BancoID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["BancoID"]);
Banco oBan = new Banco();
oBan.Nombre = (reader["BancoNm"] == DBNull.Value) ? "" : reader["BancoNm"].ToString();
entidad.Banco = oBan;
entidad.MonedaID = (reader["MonedaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["MonedaID"]);
Moneda oMon = new Moneda();
oMon.Nombre = (reader["MonedaNm"] == DBNull.Value) ? "" : reader["MonedaNm"].ToString();
entidad.Moneda = oMon;
entidad.Fecha = Convert.ToDateTime(reader["Fecha"]);
entidad.NroCheque = (reader["NroCheque"] == DBNull.Value) ? "" : reader["NroCheque"].ToString();
entidad.Monto = (reader["Monto"] == DBNull.Value) ? 0 : Convert.ToDecimal(reader["Monto"]);
entidad.Concepto = (reader["Concepto"] == DBNull.Value) ? "" : reader["Concepto"].ToString();
lstCheque.Add(entidad);
}
}
recordCount = Convert.ToInt32(comando.Parameters["@vi_RecordCount"].Value);
}
}
}
catch (Exception ex)
{
clientResponse.Mensaje = ex.Message;
clientResponse.Status = "ERROR";
}
finally
{
conexion.Close();
conexion.Dispose();
comando.Dispose();
reader.Dispose();
}
Pagination responsepaginacion = new Pagination()
{
TotalItems = recordCount,
TotalPages = (int)Math.Ceiling((double)recordCount / 10)
//TotalPages = (int)Math.Ceiling((double)recordCount / objeto.ItemsPerPage)
};
clientResponse.DataJson = JsonConvert.SerializeObject(lstCheque).ToString();
clientResponse.paginacion = JsonConvert.SerializeObject(responsepaginacion).ToString();
return(clientResponse);
}
private void CreateChequeStatus(Cheque cheque, ChequeModel model, DateTime today)
{
ChequeStatu chequeStatus = new ChequeStatu();
chequeStatus.Cheque = cheque;
chequeStatus.ChequeStatusType = ChequeStatusType.ReceivedType;
chequeStatus.Remarks = model.Remarks;
chequeStatus.TransitionDateTime = today;
chequeStatus.IsActive = true;
Context.ChequeStatus.AddObject(chequeStatus);
}
private void ChequeModelPrepareForSave(FinancialAccount financialAccount, PartyRole customerPartyRole, int employeePartyRoleId, DateTime today, ChequeModel model)
{
if (model.IsNew)
{
var application = financialAccount.Agreement.Application;
var loanAccount = financialAccount.LoanAccount;
//new payment
Payment payment = CreatePayment(customerPartyRole, employeePartyRoleId, model, today);
//new cheque
Cheque newCheck = new Cheque();
newCheck.BankPartyRoleId = model.BankId;
newCheck.CheckDate = model.ChequeDate;
newCheck.Payment = payment;
//new cheque association
ChequeApplicationAssoc chequeAssoc = new ChequeApplicationAssoc();
chequeAssoc.Cheque = newCheck;
chequeAssoc.Application = application;
//new cheque loan association
ChequeLoanAssoc chequeLoanAssoc = new ChequeLoanAssoc();
chequeLoanAssoc.Cheque = newCheck;
chequeLoanAssoc.LoanAccount = loanAccount;
//new receipt
Receipt newReceipt = CreateReceipt(customerPartyRole, payment, model);
//new receipt payment assoc
ReceiptPaymentAssoc newReceiptAssoc = CreateReceiptPaymentAssoc(payment, newReceipt);
//new receipt status
CreateReceiptStatus(newReceipt, model, today);
//new cheque status
CreateChequeStatus(newCheck, model, today);
Context.Cheques.AddObject(newCheck);
}
else if (model.ToBeDeleted)
{
//throw new NotImplementedException();
var payment = Context.Payments.SingleOrDefault(entity => entity.Id == model.PaymentId);
var receiptPaymentAssoc = Context.ReceiptPaymentAssocs.SingleOrDefault(entity => entity.PaymentId == payment.Id);
var receipts = receiptPaymentAssoc.Receipt;
var cheque = Context.Cheques.SingleOrDefault(entity => entity.Id == model.ChequeId && entity.PaymentId == payment.Id);
var assoc = Context.ChequeApplicationAssocs.SingleOrDefault(entity => entity.ChequeId == cheque.Id);
Context.ReceiptPaymentAssocs.DeleteObject(receiptPaymentAssoc);
Context.Receipts.DeleteObject(receipts);
Context.ChequeApplicationAssocs.DeleteObject(assoc);
Context.Cheques.DeleteObject(cheque);
Context.Payments.DeleteObject(payment);
}
}
private static ChequeStatu CreateCancelledChequeStatus(Cheque cheque, DateTime today)
{
ChequeStatu chequeStatus = new ChequeStatu();
chequeStatus.Cheque = cheque;
chequeStatus.ChequeStatusType = ChequeStatusType.CancelledType;
chequeStatus.Remarks = "Cancelled due to loan restructure";
chequeStatus.TransitionDateTime = today;
chequeStatus.IsActive = true;
Context.ChequeStatus.AddObject(chequeStatus);
return chequeStatus;
}
public List<Cheque> Consultar(Cheque cheque, TipoPesquisa tipoPesquisa)
{
List<Cheque> resultado = Consultar();
switch (tipoPesquisa)
{
#region Case E
case TipoPesquisa.E:
{
if (cheque.ID != 0)
{
resultado = ((from c in resultado
where
c.ID == cheque.ID
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Parcela.HasValue)
{
resultado = ((from c in resultado
where
c.Parcela.HasValue && c.Parcela.Value == cheque.Parcela.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Agencia))
{
resultado = ((from c in resultado
where
c.Agencia.Contains(cheque.Agencia)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Banco))
{
resultado = ((from c in resultado
where
c.Banco.Contains(cheque.Banco)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Conta))
{
resultado = ((from c in resultado
where
c.Conta.Contains(cheque.Conta)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Cpf))
{
resultado = ((from c in resultado
where
c.Cpf.Contains(cheque.Cpf)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Tipo != 0)
{
resultado = ((from c in resultado
where
c.Tipo == cheque.Tipo
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Parcela.HasValue)
{
resultado = ((from c in resultado
where
c.Parcela.HasValue && c.Parcela.Value == cheque.Parcela.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.NumCheque.HasValue)
{
resultado = ((from c in resultado
where
c.NumCheque.HasValue && c.NumCheque.Value == cheque.NumCheque.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Status.HasValue)
{
resultado = ((from c in resultado
where
c.Status.HasValue && c.Status.Value == cheque.Status.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Valor.HasValue)
{
resultado = ((from c in resultado
where
c.Valor.HasValue && c.Valor.Value == cheque.Valor.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
break;
}
#endregion
#region Case Ou
case TipoPesquisa.Ou:
{
if (cheque.ID != 0)
{
resultado.AddRange((from c in Consultar()
where
c.ID == cheque.ID
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Parcela.HasValue)
{
resultado.AddRange((from c in Consultar()
where
c.Parcela.HasValue && c.Parcela.Value == cheque.Parcela.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Agencia))
{
resultado.AddRange((from c in Consultar()
where
c.Agencia.Contains(cheque.Agencia)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Banco))
{
resultado.AddRange((from c in Consultar()
where
c.Banco.Contains(cheque.Banco)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Conta))
{
resultado.AddRange((from c in Consultar()
where
c.Conta.Contains(cheque.Conta)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (!string.IsNullOrEmpty(cheque.Cpf))
{
resultado.AddRange((from c in Consultar()
where
c.Cpf.Contains(cheque.Cpf)
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Tipo != 0)
{
resultado.AddRange((from c in Consultar()
where
c.Tipo == cheque.Tipo
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Parcela.HasValue)
{
resultado.AddRange((from c in Consultar()
where
c.Parcela.HasValue && c.Parcela.Value == cheque.Parcela.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.NumCheque.HasValue)
{
resultado.AddRange((from c in Consultar()
where
c.NumCheque.HasValue && c.NumCheque.Value == cheque.NumCheque.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Status.HasValue)
{
resultado.AddRange((from c in Consultar()
where
c.Status.HasValue && c.Status.Value == cheque.Status.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
if (cheque.Valor.HasValue)
{
resultado.AddRange((from c in Consultar()
where
c.Valor.HasValue && c.Valor.Value == cheque.Valor.Value
select c).ToList());
resultado = resultado.Distinct().ToList();
}
break;
}
#endregion
default:
break;
}
return resultado;
}
public void Incluir(Cheque cheque)
{
try
{
db.Cheque.InsertOnSubmit(cheque);
}
catch (Exception)
{
throw new ChequeNaoIncluidoExcecao();
}
}
public ReportParagraph(Cheque cheque)
{
_cheque = cheque;
}
public void PrepareForSave(LoanApplication loanApplication, PartyRole customerPartyRole, int employeePartyRole, DateTime today)
{
if (this.IsNew)
{
var assoc = Context.ChequeApplicationAssocs.Where(e => e.ApplicationId == loanApplication.ApplicationId);
if (assoc != null)
{
foreach (var item in assoc)
{
var cheque = Context.Cheques.SingleOrDefault(entity => entity.Id == item.ChequeId);
var payments = Payment.GetById(cheque.PaymentId);
var rpAssoc = Context.ReceiptPaymentAssocs.SingleOrDefault(entity => entity.PaymentId == payments.Id);
Receipt receipts = Context.Receipts.SingleOrDefault(entity => entity.Id == rpAssoc.ReceiptId);
Context.ChequeApplicationAssocs.DeleteObject(item);
Context.Cheques.DeleteObject(cheque);
Context.Receipts.DeleteObject(receipts);
Context.Payments.DeleteObject(payments);
Context.ReceiptPaymentAssocs.DeleteObject(rpAssoc);
}
}
//create Payment
var transactionDate = DateTime.Today;
Payment payment = Payment.CreatePayment(today, transactionDate, customerPartyRole.Id, employeePartyRole,
this.Amount, PaymentType.Receipt, PaymentMethodType.PersonalCheckType,
SpecificPaymentType.LoanPaymentType, this.ChequeNumber);
Context.Payments.AddObject(payment);
//create cheque
Cheque newCheck = new Cheque();
newCheck.BankPartyRoleId = this.BankId;
newCheck.CheckDate = this.ChequeDate;
newCheck.Payment = payment;
Context.Cheques.AddObject(newCheck);
//create cheque association
ChequeApplicationAssoc chequeAssoc = new ChequeApplicationAssoc();
chequeAssoc.Cheque = newCheck;
chequeAssoc.Application = loanApplication.Application;
//create receipt and receipt payment assoc
Receipt receipt = Receipt.CreateReceipt(null, this.Amount);
Receipt.CreateReceiptPaymentAssoc(receipt, payment);
//Context.SaveChanges();
}
else if (this.ToBeDeleted)
{
var payment = Payment.GetById(this.PaymentId);
//TODO:: Changed to new payment
var cheque = Context.Cheques.SingleOrDefault(entity => entity.Id == this.ChequeId && entity.PaymentId == payment.Id);
var rpAssoc = Context.ReceiptPaymentAssocs.SingleOrDefault(entity => entity.PaymentId == payment.Id);
var assoc = Context.ChequeApplicationAssocs.SingleOrDefault(entity => entity.ChequeId == cheque.Id);
//TODO:: Changed to new payment
Context.ChequeApplicationAssocs.DeleteObject(assoc);
Context.Cheques.DeleteObject(cheque);
Context.Receipts.DeleteObject(rpAssoc.Receipt);
Context.Payments.DeleteObject(rpAssoc.Payment);
Context.ReceiptPaymentAssocs.DeleteObject(rpAssoc);
}
else if (this.IsNew == false && this.ToBeDeleted == false)
{
var payment = Context.Payments.SingleOrDefault(entity => entity.Id == this.PaymentId);
payment.TransactionDate = this.TransactionDate;
payment.PaymentReferenceNumber = this.ChequeNumber;
var cheque = Context.Cheques.SingleOrDefault(entity => entity.Id == this.ChequeId && entity.PaymentId == payment.Id);
cheque.BankPartyRoleId = this.BankId;
}
}
public void Actualizar(Cheque cheque)
{
_context.Cheque.Attach(cheque);
_context.Entry(cheque).State = EntityState.Modified;
_context.SaveChanges();
}
public bool Put([FromBody] Cheque cheque)
{
return(_chequeRepository.UpdateCheque(cheque));
}
protected void add_Callback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
List <Payment> payments;
if (e.Parameters == "clear")
{
Session["listPayment"] = null;
}
#region Add Payment
else
{
payments = new List <Payment>();
decimal amount = 0.0M, amountCheque = 0.0M, amountChequeForTransaction = 0.0M;
if (cbxPayMethod.SelectedItem == null)
{
throw new ApplicationException("เลือกวิธีการชำระเงิน");
}
String payMethod = (String)cbxPayMethod.SelectedItem.Value;
String payType = (cbxPayType.SelectedItem == null ? "Cash" : (String)cbxPayType.SelectedItem.Value);
//Party payee = Organization.FindByCode(iSabayaContext, CommonConstants.PayeeOrgCode);
Payment payment = null;
#region BankDeposit
if (payMethod.Equals("BankAccountDeposit"))
{
BankDeposit bankDeposit = new BankDeposit();
bankDeposit.PaymentType = "BankDeposit";
if (payType.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
bankDeposit.Amount = new Money(amount, iSabayaContext.imSabayaConfig.DefaultCurrency);
bankDeposit.BankAccount = ToBankAccount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.AmountForThisTransaction = amount;
}
else if (payType.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New Cheque
{
payment = new Cheque();
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.StatusDate = DateTime.Now;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PaymentDate = paymentDate.Date;
cheque.PrintChequeDate = TimeInterval.MaxDate;
bankDeposit.Amount = cheque.Amount;
bankDeposit.BankAccount = ToBankAccount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.DueDate = cheque.DueDate.Date;
bankDeposit.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Cheque = cheque;
}
else // 0ld Cheque
{
c.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Amount = c.Amount;
bankDeposit.PaymentDate = paymentDate.Date;
bankDeposit.DueDate = c.DueDate.Date;
bankDeposit.AmountForThisTransaction = amountChequeForTransaction;
bankDeposit.Cheque = c;
}
}
payments.Add(bankDeposit);
}
#endregion BankDeposit
#region FundTransfer
else if (payMethod.Equals("FundTransfer"))
{
amount = (decimal)spnAmount.Value;
FundTransfer fundTransfer = new FundTransfer();
fundTransfer.PaymentType = "FundTransfer";
fundTransfer.FromBankAccount = FromBankAccount;
fundTransfer.ToBankAccount = ToBankAccount;
fundTransfer.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
fundTransfer.AmountForThisTransaction = fundTransfer.Amount.Amount;
fundTransfer.PaymentDate = DateTime.Now;
if (fundTransfer.FromBankAccount == null)
{
throw new ApplicationException("ไม่พบบัญชีต้นทาง");
}
if (fundTransfer.ToBankAccount == null)
{
throw new ApplicationException("ไม่พบบัญชีปลายทาง");
}
payments.Add(fundTransfer);
}
#endregion FundTransfer
#region Cash
else if (payMethod.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
Cash cash = (Cash)payment;
cash.PaymentType = "Cash";
cash.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
cash.PaymentDate = DateTime.Now.Date;
cash.AmountForThisTransaction = amount;
payments.Add(cash);
}
#endregion Cash
#region Cheque
else if (payMethod.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New cheque
{
payment = new Cheque();
payment.PaymentType = "Cheque";
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.PaymentDate = DateTime.Now.Date;
cheque.StatusDate = DateTime.Now;
cheque.PrintChequeDate = TimeInterval.MinDate;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PayableTo = "";
cheque.PrintChequeDate = TimeInterval.MaxDate;
payments.Add(cheque);
}
else
{
c.AmountForThisTransaction = amountChequeForTransaction;
payments.Add(c);
}
}
#endregion Cheque
#region BillPayment
else if (payMethod.Equals("BillPayment"))
{
//no class
BillPayment billPayment = new BillPayment();
billPayment.PaymentType = "Bill Payment";
if (payType.Equals("Cash"))
{
amount = (decimal)spnAmount.Value;
payment = new Cash();
Cash cash = (Cash)payment;
billPayment.Amount = new Money(Convert.ToDecimal(amount.ToString()), iSabayaContext.imSabayaConfig.DefaultCurrency);
billPayment.PaymentDate = paymentDate.Date.Date;
billPayment.AmountForThisTransaction = amount;
}
else if (payType.Equals("Cheque"))
{
amountCheque = (decimal)spnChequeAmount.Value;
amountChequeForTransaction = (decimal)spnChequeUsedAmount.Value;
Cheque c = FindByChequeNo(iSabayaContext, bteChequeNo.Text);
if (c == null) // New cheque
{
payment = new Cheque();
Cheque cheque = (Cheque)payment;
cheque.Amount = new Money(amountCheque, iSabayaContext.imSabayaConfig.DefaultCurrency);
cheque.PaymentDate = paymentDate.Date.Date;
cheque.StatusDate = paymentDate.Date.Date;
cheque.AmountForThisTransaction = amountChequeForTransaction;
cheque.Bank = BankControl1.Organization;
cheque.ChequeNo = bteChequeNo.Text;
cheque.ChequeDate = (DateTime)ChequeDate.Date;
cheque.PayableTo = "";
cheque.PrintChequeDate = TimeInterval.MaxDate;
//special for bank deposit
billPayment.Amount = cheque.Amount;
billPayment.PaymentDate = cheque.PaymentDate;
billPayment.DueDate = cheque.DueDate.Date;
billPayment.AmountForThisTransaction = amountChequeForTransaction;
//special for bank deposit
billPayment.Cheque = cheque;
}
else // Old cheque
{
c.AmountForThisTransaction = amountChequeForTransaction;
billPayment.Cheque = c;
}
}
payments.Add(billPayment);
}
#endregion BillPayment
Session["listPayment"] = payments;
}
#endregion Add Payment
gridPaymetod.DataSource = Session["listPayment"];
gridPaymetod.DataBind();
}
public void Excluir(Cheque cheque)
{
try
{
Cheque chequeAux = new Cheque();
chequeAux.ID = cheque.ID;
List<Cheque> resultado = this.Consultar(chequeAux, TipoPesquisa.E);
if (resultado == null || resultado.Count == 0)
throw new ChequeNaoExcluidoExcecao();
chequeAux = resultado[0];
db.Cheque.DeleteOnSubmit(chequeAux);
}
catch (Exception)
{
throw new ChequeNaoExcluidoExcecao();
}
}
public MemoryStream Render(Cheque cheque)
{
var stream = new MemoryStream();
return(ConstructReport(stream, cheque));
}
public abstract void Devolver(Cheque cheque, DateTime dataEvento, string motivo);
/************* Metodos privados *************/
private void realizarRetiro()
{
Boolean validador;
validador = Validaciones.validarCampoVacio(txtNroDoc) & Validaciones.validarCampoVacio(txtImporte) & Validaciones.validarCampoVacio(txtNroCheque) & Validaciones.validarCampoVacio(txtNombreLibrar);
validador = validador & Validaciones.validarCampoNumericoDouble(txtImporte) & Validaciones.validarCampoNumericoEntero(txtNroDoc) & Validaciones.validarCampoNumericoEntero(txtNroCheque) & Validaciones.validarCampoString(txtNombreLibrar);
if (validador)
{
try
{
validarCuentaHabilitada();
validarSaldoDisponible();
validarNumeroDocumento();
validarImporteEnDolares();
Cheque cheque = new Cheque();
cheque.numero = Int64.Parse(txtNroCheque.Text);
cheque.fecha = FECHA_ACTUAL;
cheque.importe = Double.Parse(txtImporte.Text);
cheque.codigoBanco = ((Banco)comboBanco.SelectedItem).codigo;
cheque.monedaTipo = ((TipoMoneda)comboTipoMoneda.SelectedItem).codigo;
cheque.nombreDestinatario = txtNombreLibrar.Text;
Entities.Retiro retiro = new Entities.Retiro();
retiro.cheque = cheque;
retiro.importe = cheque.importe;
retiro.fecha = cheque.fecha;
retiro.cuenta = Int64.Parse(comboCuentaOrigen.Text);
retiro.codigoCheque = cheque.numero;
retiroService.GuardarRetiro(retiro);
MessageBox.Show("Se ha realizado el retiro de saldo. ", "Retiro realizado satisfactoriamente", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiarDatos();
}
catch (OperationCanceledException ex)
{
MessageBox.Show(ex.Message.ToString(), "No se pudo realizar el retiro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
MessageBox.Show("El numero de cheque ya existe", "No se pudo realizar el retiro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public int SendCheque(Cheque cheque)
{
return(_chequeRepository.SaveCheque(cheque));
}
public HttpResponseMessage Get()
{
var cheque = new Cheque();
return(ToJson(cheque));
}
public async Task <HttpResponseMessage> SaveReceiveAndPay([FromBody] PayRecevie payRecevie)
{
try
{
var organId = Convert.ToInt32(SecurityManager.CurrentUserContext.OrganizationId);
FinanYearRule finanYearRule = new FinanYearRule();
var finanYerar = await finanYearRule.GetCurrentFinanYear(organId);
var documentNumber = 0;
int payRecevieNumber = 0;
if (payRecevie.ID > 0)
{
PayRecevie temp = new PayRecevie();
temp = payRecevie;
PayRecevieRule payRecevieRule = new PayRecevieRule();
payRecevieRule.Delete(payRecevie.ID);
documentNumber = payRecevie.Document.Number;
payRecevieNumber = payRecevie.Number;
await payRecevieRule.SaveChangesAsync();
}
payRecevie.ID = -1;
if (payRecevie.Contact != null)
{
payRecevie.ContactId = payRecevie.Contact.ID;
payRecevie.Contact.ObjectState = OMF.Common.Enums.ObjectState.Unchanged;
}
if (payRecevie.Invoice != null)
{
payRecevie.InvoiceId = payRecevie.Invoice.ID;
payRecevie.Invoice.ObjectState = OMF.Common.Enums.ObjectState.Unchanged;
}
if (payRecevie.Cost != null)
{
payRecevie.CostId = payRecevie.Cost.ID;
payRecevie.Cost.ObjectState = OMF.Common.Enums.ObjectState.Unchanged;
}
payRecevie.OrganId = organId;
payRecevie.Type = payRecevie.Type;
payRecevie.Date = PersianDateUtils.ToDateTime(payRecevie.DisplayDate);
payRecevie.DisplayDate = payRecevie.DisplayDate;
// payRecevie.Date = DateTime.Now;
//payRecevie.DisplayDate = Utilities.PersianDateUtils.ToPersianDate(DateTime.Now);
decimal amount = 0;
foreach (var item in payRecevie.Items)
{
amount += item.Amount;
if (item.Cash != null)
{
item.CashId = item.Cash.ID;
}
else if (item.Bank != null)
{
item.BankId = item.Bank.ID;
}
else if (item.Cheque != null && item.Type == ZhivarEnums.DetailPayReceiveType.Cheque)
{
Cheque cheque = new Cheque()
{
Amount = item.Amount,
BankBranch = item.Cheque.BankBranch,
BankName = item.Cheque.BankName,
ChequeNumber = item.Cheque.ChequeNumber,
Contact = payRecevie.Contact,
ContactId = payRecevie.Contact.ID,
Date = PersianDateUtils.ToDateTime(item.Cheque.DisplayDate),
OrganId = organId,
Status = ZhivarEnums.ChequeStatus.Normal,
DisplayDate = item.Cheque.DisplayDate,
};
if (payRecevie.IsReceive)
{
cheque.Type = ZhivarEnums.ChequeType.Dareaftani;
}
else
{
cheque.Type = ZhivarEnums.ChequeType.Pardakhtani;
}
if (item.Cheque.ReceiptDate != null)
{
cheque.ReceiptDate = item.Cheque.ReceiptDate;
}
item.Cheque = cheque;
item.ChequeId = item.Cheque.ID;
item.Cheque.ObjectState = OMF.Common.Enums.ObjectState.Added;
if (!payRecevie.IsReceive)
{
var temp = item.ChequeBank.ID;
item.ChequeBank = new ChequeBank()
{
BankId = temp,
ChequeId = item.Cheque.ID,
OrganId = organId
};
item.ChequeBank.ObjectState = OMF.Common.Enums.ObjectState.Added;
item.ChequeBankId = item.ChequeBank.ID;
}
item.ObjectState = OMF.Common.Enums.ObjectState.Added;
}
if (item.Type == ZhivarEnums.DetailPayReceiveType.KharjCheque)
{
ChequeRule chequeRule = new ChequeRule();
var cheque = await chequeRule.FindAsync(item.Cheque.ID);
cheque.Status = ZhivarEnums.ChequeStatus.Sold;
chequeRule.Update(cheque);
await chequeRule.SaveChangesAsync();
item.Cheque.ContactId = item.Cheque.Contact.ID;
}
item.ObjectState = OMF.Common.Enums.ObjectState.Added;
}
payRecevie.Amount = amount;
if (payRecevie.Invoice != null)
{
//if (payRecevie.Invoice.Contact != null)
payRecevie.Invoice.ContactId = payRecevie.Invoice.ContactId;
//payRecevie.Invoice.FinanYear = finanYerar;
//payRecevie.Invoice.FinanYearId = finanYerar.ID;
var invoice = payRecevie.Invoice;
invoice.Rest -= amount;
invoice.Paid += amount;
if (invoice.Rest <= 0)
{
invoice.Status = ZhivarEnums.NoeInsertFactor.Received;
}
this.BusinessRule.UnitOfWork.RepositoryAsync <Invoice>().Update(invoice);
}
if (payRecevie.Cost != null)
{
//if (payRecevie.Cost.Contact != null)
payRecevie.Cost.ContactId = payRecevie.Cost.ContactId;
var cost = payRecevie.Cost;
cost.Rest -= amount;
cost.Paid += amount;
if (cost.Rest <= 0)
{
cost.Status = ZhivarEnums.CostStatus.Paid;
}
this.BusinessRule.UnitOfWork.RepositoryAsync <Cost>().Update(cost);
}
payRecevie.Document = await createDocument(payRecevie, organId, documentNumber);
if (payRecevieNumber > 0)
{
payRecevie.Number = payRecevieNumber;
}
else
{
var payRecevies = await Rule.GetAllByOrganIdAsync(organId);
var lastPayRecevies = payRecevies.OrderByDescending(x => x.ID).FirstOrDefault();
if (lastPayRecevies != null)
{
payRecevie.Number = lastPayRecevies.Number + 1;
}
else
{
payRecevie.Number = 1;
}
}
foreach (var transaction in payRecevie.Document.Transactions)
{
transaction.ObjectState = OMF.Common.Enums.ObjectState.Added;
//if (transaction.AccDocument != null)
// transaction.AccDocument.ObjectState = OMF.Common.Enums.ObjectState.Unchanged;
if (transaction.Account != null)
{
transaction.Account.ObjectState = OMF.Common.Enums.ObjectState.Unchanged;
}
// transaction.Transactions = null;
}
payRecevie.Document.ObjectState = OMF.Common.Enums.ObjectState.Added;
payRecevie.ObjectState = OMF.Common.Enums.ObjectState.Added;
this.BusinessRule.UnitOfWork.RepositoryAsync <PayRecevie>().InsertOrUpdateGraph(payRecevie);
await this.BusinessRule.UnitOfWork.SaveChangesAsync();
return(Request.CreateResponse(HttpStatusCode.OK, new { resultCode = (int)ZhivarEnums.ResultCode.Successful, data = payRecevie }));
}
catch (Exception ex)
{
throw;
}
}
public HttpResponseMessage Error()
{
var cheque = new Cheque();
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Invalid cheque date"));
}
public Cheque ajouterCheque(Cheque c)
{
return(idao.ajouterCheque(c));
}
public async Task<ActionResult> GetChequesByCount(Cheque cheque)
{
Log.Info("Received a request to save the receipt");
return Ok(await _chequeRepository.Insert(cheque));
}
public void Add(Cheque cheque)
{
List.Add(cheque);
}
public RemovedChequeEvent(Cheque cheque) : base(cheque)
{
}
public ChequeModel(Cheque cheque)
{
this.IsNew = false;
this.Amount = cheque.Payment.TotalAmount;
var Bank = Context.Banks.SingleOrDefault(entity => entity.PartyRoleId == cheque.BankPartyRoleId);
this.BankId = Bank.PartyRoleId;
this.BankName = Bank.PartyRole.Party.Organization.OrganizationName;
this.ChequeId = cheque.Id;
this.ChequeNumber = cheque.Payment.PaymentReferenceNumber;
this.TransactionDate = cheque.Payment.TransactionDate;
this.ChequeDate = cheque.CheckDate;
this.PaymentId = cheque.PaymentId;
this.ReceiptId = cheque.PaymentId;
var chequeStatus = Context.ChequeStatus.SingleOrDefault(entity => entity.CheckId == cheque.Id && entity.IsActive == true);
if (chequeStatus != null)
{
this.Status = chequeStatus.ChequeStatusType.Name;
}
}
public override void Repassar(Cheque cheque, DateTime dataEvento, Fornecedor fornecedor)
{
cheque.MudarEstado(new ChequeRepassado(dataEvento, fornecedor));
}
public ClientResponse getObtenerChequeXId(int ID)
{
try
{
using (conexion = new SqlConnection(ConexionDAO.cnx))
{
using (comando = new SqlCommand("usp_sel_cheque_x_id", conexion))
{
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@id", ID);
conexion.Open();
using (reader = comando.ExecuteReader())
{
if (reader.Read())
{
entidad = new Cheque();
entidad.ID = (reader["ID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"].ToString());
entidad.CampaniaID = (reader["CampaniaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["CampaniaID"]);
using (CampañasDAO oCampDao = new CampañasDAO())
{
entidad.listCampañas = oCampDao.ListarCampañas();
}
entidad.InstitucionEducativaID = (reader["InstitucionEducativaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["InstitucionEducativaID"]);
using (InstitucionEducativaDAO db = new InstitucionEducativaDAO())
{
entidad.listInstitucionEducativa = db.getLstByCampania(entidad.CampaniaID);
}
using (CiaSeguro_DAO db = new CiaSeguro_DAO())
{
entidad.listCIASeguro = db.getLstbyInst(entidad.InstitucionEducativaID);
}
entidad.CIASeguroID = (reader["CIASeguroID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["CIASeguroID"]);
using (TipoSeguro_DAO db = new TipoSeguro_DAO())
{
entidad.listProducto = db.getLstbyInstAseg(entidad.InstitucionEducativaID, entidad.CIASeguroID);
}
entidad.ProductoID = (reader["ProductoID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["ProductoID"]);
entidad.BancoID = (reader["BancoID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["BancoID"]);
entidad.MonedaID = (reader["MonedaID"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["MonedaID"]);
using (BancoDAO db = new BancoDAO())
{
entidad.listBanco = db.ListarBanco();
}
using (MonedaDAO db = new MonedaDAO())
{
entidad.listMoneda = db.getLstbyInstAsegProd(entidad.InstitucionEducativaID, entidad.CIASeguroID, entidad.ProductoID);
}
entidad.Fecha = Convert.ToDateTime(reader["Fecha"]);
entidad.NroCheque = (reader["NroCheque"] == DBNull.Value) ? "" : reader["NroCheque"].ToString();
entidad.Monto = (reader["Monto"] == DBNull.Value) ? 0 : Convert.ToDecimal(reader["Monto"]);
entidad.Concepto = (reader["Concepto"] == DBNull.Value) ? "" : reader["Concepto"].ToString();
}
}
}
}
}
catch (Exception ex)
{
clientResponse.Mensaje = ex.Message;
clientResponse.Status = "ERROR";
}
finally
{
conexion.Close();
conexion.Dispose();
comando.Dispose();
reader.Dispose();
}
clientResponse.DataJson = JsonConvert.SerializeObject(entidad).ToString();
return(clientResponse);
}
public override void Devolver(Cheque cheque, DateTime dataEvento, string motivo)
{
cheque.MudarEstado(new ChequeDevolvido(dataEvento, motivo));
}
public ClientResponse Grabar(Cheque cheque)
{
try
{
using (conexion = new SqlConnection(ConexionDAO.cnx))
{
using (comando = new SqlCommand("usp_upd_cheque", conexion))
{
comando.Parameters.AddWithValue("@CampaniaID", cheque.CampaniaID);
comando.Parameters.AddWithValue("@InstitucionEducativaID", cheque.InstitucionEducativaID);
comando.Parameters.AddWithValue("@CIASeguroID", cheque.CIASeguroID);
comando.Parameters.AddWithValue("@ProductoID", cheque.ProductoID);
comando.Parameters.AddWithValue("@BancoID", cheque.BancoID);
comando.Parameters.AddWithValue("@MonedaID", cheque.MonedaID);
comando.Parameters.AddWithValue("@fecha", cheque.Fecha);
comando.Parameters.AddWithValue("@NroCheque", cheque.NroCheque);
comando.Parameters.AddWithValue("@Monto", cheque.Monto);
comando.Parameters.AddWithValue("@UsuarioActualizacion", cheque.UsuarioActualizacion);
comando.Parameters.AddWithValue("@FechaActualizacion", cheque.FechaActualizacion);
comando.Parameters.AddWithValue("@Activo", cheque.Activo);
comando.Parameters.AddWithValue("@id", cheque.ID);
comando.Parameters.Add("@mensaje", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
comando.Parameters.Add("@status", SqlDbType.VarChar, 5).Direction = ParameterDirection.Output;
comando.CommandType = CommandType.StoredProcedure;
conexion.Open();
comando.ExecuteNonQuery();
//clientResponse.Mensaje = "El cheque se ha Actualizado Satisfactoriamente.";
//clientResponse.Status = "OK";
clientResponse.Mensaje = comando.Parameters["@mensaje"].Value.ToString();
clientResponse.Status = comando.Parameters["@status"].Value.ToString();
if (clientResponse.Status == "ERROR")
{
throw new Exception(clientResponse.Mensaje);
}
}
}
}
catch (Exception ex)
{
clientResponse.Mensaje = ex.Message;
clientResponse.Status = "ERROR";
}
finally
{
conexion.Close();
conexion.Dispose();
comando.Dispose();
}
return(clientResponse);
//using (BDHermesBancarizacionEntities db = new BDHermesBancarizacionEntities())
//{
// bool existe = (db.Cheque.Where(p => p.ID == cheque.ID).Count() > 0);
// if (existe == true)
// {
// Cheque oCheque = db.Cheque.Where(p => p.ID == cheque.ID).FirstOrDefault();
// oCheque.ID = cheque.ID;
// oCheque.CampaniaID = cheque.CampaniaID;
// oCheque.InstitucionEducativaID = cheque.InstitucionEducativaID;
// oCheque.CIASeguroID = cheque.CIASeguroID;
// oCheque.ProductoID = cheque.ProductoID;
// oCheque.BancoID = cheque.BancoID;
// oCheque.MonedaID = cheque.MonedaID;
// oCheque.Fecha = cheque.Fecha;
// oCheque.NroCheque = cheque.NroCheque;
// oCheque.Monto = cheque.Monto;
// oCheque.UsuarioActualizacion = cheque.UsuarioActualizacion;
// oCheque.FechaActualizacion = cheque.FechaActualizacion;
// }
// return db.SaveChanges();
//}
}
public abstract void Bloquear(Cheque cheque, DateTime dataEvento);
public override void Bloquear(Cheque cheque, DateTime dataEvento)
{
cheque.MudarEstado(new ChequeBloqueado(dataEvento));
}
public abstract void Compensar(Cheque cheque, DateTime dataEvento);
public override void Repassar(Cheque cheque, DateTime dataEvento, Cliente cliente)
{
cheque.MudarEstado(new ChequeRepassado(dataEvento, cliente));
}
public abstract void Repassar(Cheque cheque, DateTime dataEvento, Fornecedor fornecedor);
