public HttpResponseMessage Add_Client(TLSCliente cliente, int idAccount, double balance, string tipoCuenta)
{
var transaction = db.Database.BeginTransaction();
try
{
TLSCuenta cuenta = new TLSCuenta()
{
IDCuenta = idAccount,
Cedula = cliente.Cedula,
Balance = balance,
TipoCuenta = tipoCuenta
};
var insert = db.InsertCliente(cliente.Nombre, cliente.Apellido, cliente.Email, cliente.Fecha, cliente.EmpresaTrabajo, cliente.PuestoTrabajo, cliente.Sueldo, cliente.Cuenta, cliente.Cedula, cliente.Sexo);
var insertAccount = db.InsertCuenta(cuenta.IDCuenta, cuenta.Cedula, cuenta.Balance, cuenta.TipoCuenta, DateTime.Now);
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"Client {insert} row affected", $"{EnumLevelLogs.DEBUG}");
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"Account {insertAccount} row affected", $"{EnumLevelLogs.DEBUG}");
var ok = db.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.Accepted, $"the client and account is saved {ok}"));
}
catch (Exception ex)
{
db.InsertLogs(EnumLevelLogs.ERROR.ToString(), $"0 row affected", $"{ex.Message}");
transaction.Rollback();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, $"{ex.Message}"));
}
}
public HttpResponseMessage UpdateAccount(TLSCuenta cuenta)
{
var transaction = db.Database.BeginTransaction();
try
{
var update = db.UpdateCuenta(cuenta.IDCuenta, cuenta.Cedula, cuenta.Balance, cuenta.TipoCuenta, cuenta.FechaActualizacion);
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"Account {update} row update", $"{EnumLevelLogs.DEBUG}");
var ok = db.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.Accepted, "the Account is update"));
}
catch (Exception ex)
{
db.InsertLogs(EnumLevelLogs.ERROR.ToString(), $"Account0 row update", $"{ex.Message}");
transaction.Rollback();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, $"{ex.Message}"));
}
}
public HttpResponseMessage AddCuenta(TLSCuenta cuenta)
{
var transaction = db.Database.BeginTransaction();
try
{
var insert = db.InsertCuenta(cuenta.IDCuenta, cuenta.Cedula, cuenta.Balance, cuenta.TipoCuenta, DateTime.Now);
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"Account {insert} row affected", $"{EnumLevelLogs.DEBUG}");
var ok = db.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.Accepted, "the account is saved"));
}
catch (Exception ex)
{
db.InsertLogs(EnumLevelLogs.ERROR.ToString(), $"Account 0 row affected", $"{ex.Message}");
transaction.Rollback();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, $"{ex.Message}"));
}
}
public IHttpActionResult GetAccountId(int idAccount)
{
TLSCuenta cuenta = null;
try
{
cuenta = db.TLSCuentas.ToList().Find(e => e.IDCuenta == idAccount);
}
catch (Exception)
{
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"not fount", $"{EnumLevelLogs.DEBUG}");
}
if (cuenta != null)
{
var json = Newtonsoft.Json.JsonConvert.SerializeObject(User);
db.InsertLogs(EnumLevelLogs.DEBUG.ToString(), $"{cuenta.IDCuenta} found", $"{EnumLevelLogs.DEBUG}");
return(Json(json));
}
return(Ok("No Account found"));
}
