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); }