public JsonResult GetCommissionsHeader(string childID, int type)
{
var usr = (Login)System.Web.HttpContext.Current.Session["usr"];
var commission = new OutCommissionsHeader();
string executiveID = string.Empty;
if (usr == null)
{
RedirectToAction("Index", "Home");
return(null);
}
if (type != 4)
{
executiveID = usr.userName;
}
if (childID != null)
{
executiveID = childID;
}
commission = new ManageCommissions().GetCommissionsHeader(executiveID);
return(new JsonResult {
Data = commission, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public OutCommissionsHeader GetCommissionsHeader(string executiveID)
{
OutCommissionsHeader data = new OutCommissionsHeader();
try
{
CommissionsDAO dao = new CommissionsDAO();
data = dao.GetCommissionsHeader(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageCommissions", "GetCommissionsHeader", ex, "");
}
return(data);
}
public OutCommissionsHeader GetCommissionsHeader(string executiveID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutCommissionsHeader response = new OutCommissionsHeader();
var ora = new OracleServer(connectionString);
CommissionHeader commission;
List <CommissionHeader> list = new List <CommissionHeader>();
string command = string.Empty;
try
{
command = " SELECT CODIGO_CUENTA, CODIGO_SUCURSAL, NOMBRE_SUCURSAL, TIPO_PROMOTOR, NOMBRE_TIPO_PROMOTOR,CODIGO_PUESTO, NOMBRE_CODIGO_PUESTO, " +
" CODIGO_CATEGORIA, NOMBRE_CATEGORIA, CODIGO_CATEGORIA_ANT, NOMBRE_CATEGORIA_ANTERIOR, PUNTOS_ACUM_MES_ANTERIOR, COMISIONES_MES_ANTERIOR, " +
" CODIGO_EJECUTIVO, NOMBRE_EJECUTIVO, DIRECCION_NOTIFICACION, CEDULA, TELEFONO_EJECUTIVO, ESTADO, DESCRIPCION_ESTADO, CORREO_ELECTRONICO, " +
" CORREO_ELE_NOTIFICACION,CORREO_ELE_BAYPORT,FECHA_NACTO, CODIGO_JEFE_CCIAL, NOMBRE_JEFE_CCIAL,TELEFONO_JEFE_CCIAL, ";
command = command + string.Format(" CORREO_JEFE_CCIAL, SALDO_COMISION, RFC,NOMBRE_DIVISION, NOMBRE_REGION FROM BBS_LIQCOM_V_CUENTAS WHERE cedula = '{0}' ", executiveID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
commission = new CommissionHeader();
commission.accountCode = DBNull.Value.Equals(rdr["CODIGO_CUENTA"]) ? 0 : double.Parse(rdr["CODIGO_CUENTA"].ToString());
commission.branchCode = DBNull.Value.Equals(rdr["CODIGO_SUCURSAL"]) ? 0 : double.Parse(rdr["CODIGO_SUCURSAL"].ToString());
commission.branchName = DBNull.Value.Equals(rdr["NOMBRE_SUCURSAL"]) ? string.Empty : rdr["NOMBRE_SUCURSAL"].ToString();
commission.executiveType = DBNull.Value.Equals(rdr["TIPO_PROMOTOR"]) ? 0 : double.Parse(rdr["TIPO_PROMOTOR"].ToString());
commission.executiveTypeName = DBNull.Value.Equals(rdr["NOMBRE_TIPO_PROMOTOR"]) ? string.Empty : rdr["NOMBRE_TIPO_PROMOTOR"].ToString();
commission.positionCode = DBNull.Value.Equals(rdr["CODIGO_PUESTO"]) ? 0 : double.Parse(rdr["CODIGO_PUESTO"].ToString());
commission.positionCodeName = DBNull.Value.Equals(rdr["NOMBRE_CODIGO_PUESTO"]) ? string.Empty : rdr["NOMBRE_CODIGO_PUESTO"].ToString();
commission.categoryCode = DBNull.Value.Equals(rdr["CODIGO_CATEGORIA"]) ? 0 : double.Parse(rdr["CODIGO_CATEGORIA"].ToString());
commission.categoryName = DBNull.Value.Equals(rdr["NOMBRE_CATEGORIA"]) ? string.Empty : rdr["NOMBRE_CATEGORIA"].ToString();
commission.previousCategoryCode = DBNull.Value.Equals(rdr["CODIGO_CATEGORIA_ANT"]) ? 0 : double.Parse(rdr["CODIGO_CATEGORIA_ANT"].ToString());
commission.previousCategoryName = DBNull.Value.Equals(rdr["NOMBRE_CATEGORIA_ANTERIOR"]) ? string.Empty : rdr["NOMBRE_CATEGORIA_ANTERIOR"].ToString();
commission.previousPointsAccum = DBNull.Value.Equals(rdr["PUNTOS_ACUM_MES_ANTERIOR"]) ? 0 : double.Parse(rdr["PUNTOS_ACUM_MES_ANTERIOR"].ToString());
commission.previousCommissionBalance = DBNull.Value.Equals(rdr["COMISIONES_MES_ANTERIOR"]) ? 0 : double.Parse(rdr["COMISIONES_MES_ANTERIOR"].ToString());
commission.executiveCode = DBNull.Value.Equals(rdr["CODIGO_EJECUTIVO"]) ? 0 : double.Parse(rdr["CODIGO_EJECUTIVO"].ToString());
commission.executiveName = DBNull.Value.Equals(rdr["NOMBRE_EJECUTIVO"]) ? string.Empty : rdr["NOMBRE_EJECUTIVO"].ToString();
commission.notifyAddress = DBNull.Value.Equals(rdr["DIRECCION_NOTIFICACION"]) ? string.Empty : rdr["DIRECCION_NOTIFICACION"].ToString();
commission.documentID = DBNull.Value.Equals(rdr["CEDULA"]) ? string.Empty : rdr["CEDULA"].ToString();
commission.executivePhone = DBNull.Value.Equals(rdr["TELEFONO_EJECUTIVO"]) ? string.Empty : rdr["TELEFONO_EJECUTIVO"].ToString();
commission.state = DBNull.Value.Equals(rdr["ESTADO"]) ? 0 : double.Parse(rdr["ESTADO"].ToString());
commission.stateDescription = DBNull.Value.Equals(rdr["DESCRIPCION_ESTADO"]) ? string.Empty : rdr["DESCRIPCION_ESTADO"].ToString();
commission.email = DBNull.Value.Equals(rdr["CORREO_ELECTRONICO"]) ? string.Empty : rdr["CORREO_ELECTRONICO"].ToString();
commission.notificationEmail = DBNull.Value.Equals(rdr["CORREO_ELE_NOTIFICACION"]) ? string.Empty : rdr["CORREO_ELE_NOTIFICACION"].ToString();
commission.bayportEmail = DBNull.Value.Equals(rdr["CORREO_ELE_BAYPORT"]) ? string.Empty : rdr["CORREO_ELE_BAYPORT"].ToString();
commission.birthday = DBNull.Value.Equals(rdr["FECHA_NACTO"]) ? DateTime.Today.ToString("dd/MM/yyyy") : DateTime.Parse(rdr["FECHA_NACTO"].ToString()).ToString("dd/MM/yyyy");
commission.commercialBossCode = DBNull.Value.Equals(rdr["CODIGO_JEFE_CCIAL"]) ? 0 : double.Parse(rdr["CODIGO_JEFE_CCIAL"].ToString());
commission.commercialBossName = DBNull.Value.Equals(rdr["NOMBRE_JEFE_CCIAL"]) ? string.Empty : rdr["NOMBRE_JEFE_CCIAL"].ToString();
commission.commercialBossPhone = DBNull.Value.Equals(rdr["TELEFONO_JEFE_CCIAL"]) ? string.Empty : rdr["TELEFONO_JEFE_CCIAL"].ToString();
commission.commercialBossMail = DBNull.Value.Equals(rdr["CORREO_JEFE_CCIAL"]) ? string.Empty : rdr["CORREO_JEFE_CCIAL"].ToString();
commission.commissionBalance = DBNull.Value.Equals(rdr["SALDO_COMISION"]) ? 0 : double.Parse(rdr["SALDO_COMISION"].ToString());
commission.divisionName = DBNull.Value.Equals(rdr["NOMBRE_DIVISION"]) ? string.Empty : rdr["NOMBRE_DIVISION"].ToString();
commission.regionName = DBNull.Value.Equals(rdr["NOMBRE_REGION"]) ? string.Empty : rdr["NOMBRE_REGION"].ToString();
commission.rfc = DBNull.Value.Equals(rdr["RFC"]) ? string.Empty : rdr["RFC"].ToString();
list.Add(commission);
}
rdr.Close();
response.lstCommissionHeader = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("CommissionsDAO.GetCommissionsHeader", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
