public Message Put([FromBody] GetCreditCoinsRequest request)
{
Message message = new Message();
try
{
if (request != null)
{
if (request.amount > 0 && request.clientId > 0)
{
DB db = new DB();
message = db.GetCreditCoins(request);
}
else
{
message = new Message("0035", "Ocurrio un error, El valor de los campos debe ser mayor a cero.", null);
}
}
else
{
message = new Message("0034", "Ocurrio un error, se requiere el cuerpo de la peticion.", null);
}
}
catch (Exception ex)
{
message = new Message("0033", "Ocurrio un error.", ex);
}
return(message);
}
public Message GetCreditCoins(GetCreditCoinsRequest request)
{
Message message = new Message();
try
{
Open();
string answer = "0";
command = new SqlCommand("dbo.reloadClientCredits", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@amount", request.amount);
command.Parameters.AddWithValue("@clientId", request.clientId);
reader = command.ExecuteReader();
while (reader.Read())
{
answer = reader.GetFieldValue <string>(0);
}
Close();
if (answer == "1")
{
message = new Message("0000", "Transaccion exitosa.", null);
}
else
{
message = new Message("0032", "Transaccion fallida.", null);
}
}
catch (Exception ex)
{
message = new Message("0031", "Ocurrio un error. ", ex);
}
return(message);
}
