public string Get(string userName)
{
string answer = "";
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.Get(connection, userName);
connection.Close();
}
catch (Exception e)
{
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool PutDoc(string userName, string fileName, decimal RequestedAmount)
{
bool answer = false;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.PutDoc(connection, userName, fileName, RequestedAmount);
connection.Close();
}
catch (Exception e)
{
answer = false;
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool ChangeStatus(int id, string obs, int status)
{
bool answer = false;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.ChangeStatus(connection, id, obs, status);
connection.Close();
}
catch (Exception e)
{
answer = false;
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool PutAdvancePay(decimal amount, decimal typeChange, string userName, int idMembership)
{
bool answer = false;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.PutAdvancePay(connection, amount, typeChange, userName, idMembership);
connection.Close();
}
catch (Exception e)
{
answer = false;
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool PutPayService(string data, string userName)
{
bool answer = false;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.PutPayService(connection, data, userName);
connection.Close();
}
catch (Exception e)
{
answer = false;
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool PutPayAmortization(decimal amountAmortSoles, decimal typeChangeBuy, string userName)
{
bool answer = false;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
try
{
connection.Open();
DaWallet daWallet = new DaWallet();
answer = daWallet.PutPayAmortization(connection, amountAmortSoles, typeChangeBuy, userName);
connection.Close();
}
catch (Exception e)
{
answer = false;
RecordLog(e.Message, e.StackTrace);
}
}
return(answer);
}
public bool Put(string data, string userName)
{
bool answer = false;
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
SqlTransaction transaction;
// Start a local transaction.
transaction = connection.BeginTransaction("SampleTransaction");
DaWallet daWallet = new DaWallet();
//data=amount|@idInfo|@typeInfo|@walletOperationId|@currencyCode|@typeChange|idmembershipDetail|imgTicket
try
{
answer = daWallet.Put(connection, transaction, data, userName);
}
catch (Exception ex)
{
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
string error = $"{ex.Message}|{ex2.Message}";
}
}
connection.Close();
}
}
catch (Exception e)
{
RecordLog(e.Message, e.StackTrace);
}
return(answer);
}
