public OutBalancesCommision GetBalancesCommissions(string executiveID, double accountNumber)
{
OutBalancesCommision data = new OutBalancesCommision();
try
{
CommissionsDAO dao = new CommissionsDAO();
data = dao.GetBalancesCommissions(executiveID, accountNumber);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageCommissions", "GetBalancesCommissions", ex, "");
}
return(data);
}
public OutBalancesCommision GetBalancesCommissions(string executiveID, double accountNumber)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutBalancesCommision response = new OutBalancesCommision();
var ora = new OracleServer(connectionString);
BalancesCommision balance;
List <BalancesCommision> list = new List <BalancesCommision>();
string command = string.Empty;
try
{
command = "SELECT CODIGO_CONCEPTO, NOMBRE_CONCEPTO, SALDO_CONCEPTO, CODIGO_CUENTA, CODIGO_EJECUTIVO, CEDULA, NOMBRE_EJECUTIVO ";
command = command + string.Format(" FROM BBS_LIQCOM_V_SALDOS WHERE cedula = '{0}' AND CODIGO_CUENTA = {1} ", executiveID, accountNumber);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
balance = new BalancesCommision();
balance.conceptCode = DBNull.Value.Equals(rdr["CODIGO_CONCEPTO"]) ? 0 : double.Parse(rdr["CODIGO_CONCEPTO"].ToString());
balance.conceptName = DBNull.Value.Equals(rdr["NOMBRE_CONCEPTO"]) ? string.Empty : rdr["NOMBRE_CONCEPTO"].ToString();
balance.conceptBalance = DBNull.Value.Equals(rdr["SALDO_CONCEPTO"]) ? 0 : double.Parse(rdr["SALDO_CONCEPTO"].ToString());
balance.accountCode = DBNull.Value.Equals(rdr["CODIGO_CUENTA"]) ? 0 : double.Parse(rdr["CODIGO_CUENTA"].ToString());
balance.executiveCode = DBNull.Value.Equals(rdr["CODIGO_EJECUTIVO"]) ? 0 : double.Parse(rdr["CODIGO_EJECUTIVO"].ToString());
balance.documentID = DBNull.Value.Equals(rdr["CEDULA"]) ? string.Empty : rdr["CEDULA"].ToString();
balance.executiveName = DBNull.Value.Equals(rdr["NOMBRE_EJECUTIVO"]) ? string.Empty : rdr["NOMBRE_EJECUTIVO"].ToString();
list.Add(balance);
}
rdr.Close();
response.lstBalancesCommision = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("CommissionsDAO.GetBalancesCommissions", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
