public IHttpActionResult BorrarCuenta(int id, [FromBody] string number) { try { using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { var account = context.ACCOUNTs.Where(x => x.accountnum.Trim() == number.Trim()).FirstOrDefault(); if (account == null) { return(NotFound()); } account.states = false; using (var bdContextTransaction = context.Database.BeginTransaction()) { context.Entry(account).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); bdContextTransaction.Commit(); } return(Ok(account.accountnum)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult SaveClient([FromBody] Models.ClientVO model) { try { ModelEF.CLIENT clietn = new ModelEF.CLIENT { codcliente = model.Id, name = model.Nombre }; using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { using (var bdContextTransaction = context.Database.BeginTransaction()) { context.Entry(clietn).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); bdContextTransaction.Commit(); } } return(Ok(model.Id)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
// GET: api/Account public IHttpActionResult GetAccountAll() { //nrocuenta, departamento, nombre t, moneda, saldo using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { return(Ok(context.ACCOUNTs.Select(x => x.accountnum).ToList())); } }
// GET: api/Clients public IHttpActionResult Get() { try { using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { return(Ok(context.CLIENTs.ToList())); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
// POST: api/Account public IHttpActionResult CreateAccount([FromBody] Models.AccountVO model) { try { using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { var moneda = context.COINs.Where(x => x.idcoin == model.IdMoneda).FirstOrDefault(); var depart = context.DEPARTAMENTs.Where(x => x.iddept == model.IdDepartament).FirstOrDefault(); var correlativo = context.ACCOUNTs.OrderBy(x => x.correlative).FirstOrDefault(); int correlativeNext = int.Parse(correlativo.correlative) + 1; string cuenta = moneda.codcoin + "-" + depart.coddept + "-" + correlativeNext.ToString().PadLeft(6, '0'); ModelEF.ACCOUNT account = new ModelEF.ACCOUNT { accountnum = cuenta, balance = model.Balance, codclient = model.IdClient, coddept = model.IdDepartament, correlative = correlativeNext.ToString().PadLeft(6, '0'), states = true, coin = moneda.idcoin }; using (var bdContextTransaction = context.Database.BeginTransaction()) { context.Entry(account).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); bdContextTransaction.Commit(); } return(Ok(cuenta)); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult ModificarCuenta(int id, [FromBody] Models.AccounInsertVO model) { try { using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { var mov = context.MOVEMENTs.Where(x => x.accountnum.Trim() == model.accountnum.Trim()).Count(); if (mov == 0) { var account = context.ACCOUNTs.Where(x => x.accountnum.Trim() == model.accountnum.Trim()).FirstOrDefault(); if (account == null) { return(NotFound()); } account.balance = model.balance; account.codclient = model.codclient; account.coddept = model.coddept; using (var bdContextTransaction = context.Database.BeginTransaction()) { context.Entry(account).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); bdContextTransaction.Commit(); } return(Ok(account.accountnum)); } else { return(BadRequest("tiene movimientos en la cuenta")); } } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
// GET: api/Account public IHttpActionResult GetAccount() { //nrocuenta, departamento, nombre t, moneda, saldo using (ModelEF.dbbankaplicationEntitiesBanck context = new ModelEF.dbbankaplicationEntitiesBanck()) { return(Ok(context.ACCOUNTs.Join(context.CLIENTs, acc => acc.codclient, cli => cli.codcliente, (acc, cli) => new { acc, cli }) .Join(context.DEPARTAMENTs, conbinedEntry => conbinedEntry.acc.coddept, dep => dep.iddept, (conbinedEntry, dep) => new { cuenta = conbinedEntry.acc.accountnum, departamento = dep.description, nombreCliente = conbinedEntry.cli.name, moneda = (conbinedEntry.acc.coin == 1)?"BOL":"USD", saldo = conbinedEntry.acc.balance } ).ToList() )); } }