public IHttpActionResult getTransactionStates()
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities()) {
var lsStates = db.transactionState.Where(st => st.trxst_state == true)
.Select(st => new TransactionStateViewModel
{
id = st.trxst_id,
name = st.trxst_name,
description = st.trxst_description
}).ToList();
var pendingState = new TransactionStateViewModel()
{
id = 0, name = "PENDIENTE"
};
lsStates.Add(pendingState);
return(Ok(lsStates));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult GetTodayTransactions()
{
try
{
using (DB_FleetServiceEntities db = new DB_FleetServiceEntities())
{
var rowsTransactionsDB = db.STRPRC_GET_TRANSACTIONS_TODAY1();
List <TransactionViewModel> lsTransactions = new List <TransactionViewModel>();
foreach (var trxDB in rowsTransactionsDB)
{
TransactionViewModel transaction = new TransactionViewModel();
var clientTmp = new ClientViewModel();
clientTmp.id = trxDB.cli_id;
clientTmp.document = trxDB.cli_document;
clientTmp.name = trxDB.cli_name;
clientTmp.phone = trxDB.cli_phone;
clientTmp.cellphone = trxDB.cli_cellphone;
clientTmp.website = trxDB.cli_website;
clientTmp.city = (trxDB.cty_id != null) ? new CityViewModel {
id = trxDB.cty_id
} : null;
var movementTmp = new MovementViewModel();
movementTmp.id = trxDB.m_id;
movementTmp.name = trxDB.m_name;
var trxState = new TransactionStateViewModel();
trxState.id = trxDB.trxst_id;
trxState.name = trxDB.trxst_name;
transaction.id = trxDB.trx_id;
transaction.code = trxDB.trx_code;
transaction.consecutive = trxDB.trx_consecutive;
transaction.client = clientTmp;
transaction.movement = movementTmp;
transaction.transactionState = trxState;
transaction.value = Double.Parse(trxDB.trx_value.ToString());
transaction.registrationDate = trxDB.trx_registrationDate;
transaction.user = new UserAccessViewModel();
transaction.user.id_user = trxDB.usu_id;
transaction.user.name = trxDB.usu_name;
transaction.user.lastName = trxDB.usu_lastName;
lsTransactions.Add(transaction);
}
return(Ok(lsTransactions));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
