public ResponseHelper GetHtmlElements(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_NOMBRE_TABLA", Value = param.NombreTabla
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_JSON", MySqlDbType = MySqlDbType.JSON, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_ABM_INPUTS_CONTROLS_GET";
var result = MAccess.GetSavantDataHelper <MySqlConnection, Configuracion>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public dynamic GetDetalle(ParamEntity <object> filtros)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = filtros.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_TCONTROL", Value = filtros.IdTcontrol
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = filtros.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_PERIODO", Value = filtros.Periodo
},
new MySqlParameter()
{
ParameterName = "P_ID_SECCION", Value = filtros.IdSeccion
}
};
var sqlQuery = "SP_TCONTROL_DET";
var result = MAccess.SavantGetDataDynamic <MySqlConnection>(sqlQuery, parametros);
return(result);
}
public ResponseHelper guardarConfiguracionJornadaUpd(ParamEntity <dynamic> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarConfiguracionJornadaUpd(param);
return(responseHelper);
}
public ResponseHelper logOutDatabase(ParamEntity <dynamic> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_USERLOG", Value = param.GenericData
},
new MySqlParameter()
{
ParameterName = "P_INACTIVIDAD", Value = param.Inactividad
},
new MySqlParameter()
{
ParameterName = "P_MINUTOS_INACTIVIDAD", Value = param.TiempoInactividad
}
};
var sqlQuery = "SP_USERLOG_OUT";
var responseHelper = new ResponseHelper();
responseHelper = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(responseHelper);
}
public IEnumerable <TableroCard> GetTableroCards(ParamEntity <object> filtros)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = filtros.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_PERIODO", Value = filtros.Periodo
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = filtros.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_ID_SECCION", Value = filtros.IdSeccion
}
};
var sqlQuery = "SP_TCONTROL_CAB";
var result = MAccess.GetSavantList <MySqlConnection, TableroCard>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public ResponseHelper PostAbmPlantillasJornadas(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_JSON", Value = param.Json
},
new MySqlParameter()
{
ParameterName = "P_ACCION", Value = param.Accion
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_ABM_PLANTILLAS_JORNADAS_UPD";
var result = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public ResponseHelper guardarObservacionIncidencia(ParamEntity <Novedad> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_LEGAJO", Value = param.IdLegajo
},
new MySqlParameter()
{
ParameterName = "P_FECHA", Value = param.FechaDateArray[0].Date
},
new MySqlParameter()
{
ParameterName = "P_ID_INCIDENCIA", Value = param.IdIncidencia
},
new MySqlParameter()
{
ParameterName = "P_OBSERVACIONES", Value = param.GenericEntity.Observaciones
}
};
var sqlQuery = "SP_NOV_OBSERVACIONES_UPD";
var responseHelper = new ResponseHelper();
responseHelper = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(responseHelper);
}
public Novedad GetNovedadDetalle(ParamEntity <object> filtros)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = filtros.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_LEGAJO", Value = filtros.IdLegajo
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = filtros.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_FECHA", Value = filtros.FechaDate
}
};
var sqlQuery = "SP_TCONTROL_NOV_GET";
var result = MAccess.GetSavantObject <MySqlConnection, Novedad>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public dynamic getLiqHsExtras(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa, Direction = ParameterDirection.Input
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario, Direction = ParameterDirection.Input
},
new MySqlParameter()
{
ParameterName = "P_PERIODO", MySqlDbType = MySqlDbType.VarChar, Value = param.Periodo, Direction = ParameterDirection.Input
},
new MySqlParameter()
{
ParameterName = "P_ID_SECCION", Value = param.IdSeccion, Direction = ParameterDirection.Input
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_LIQ_HS_EXTRAS_AUT_RES_GET";
var result = MAccess.SavantGetDataDynamic <MySqlConnection>(sqlQuery, parametros);
return(result);
}
/*-----------------------------POST----------------------------------*/
public ResponseHelper guardarJornada(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_LEGAJO", Value = param.IdLegajo
},
new MySqlParameter()
{
ParameterName = "P_FECHA", Value = param.FechaDate.Date
},
new MySqlParameter()
{
ParameterName = "P_ID_JORNADA", Value = param.IdJornada
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
}
};
var sqlQuery = "SP_NOVEDADES_JORNADAS_UPD";
var responseHelper = new ResponseHelper();
responseHelper = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(responseHelper);
}
public IEnumerable <Novedad> GetNovedades(ParamEntity <object> filtros)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_FECHA", Value = filtros.FechaDate
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = filtros.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = filtros.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_FECHA_NOW", Value = filtros.CurrentDateFront
}
};
var sqlQuery = "SP_NOVEDADES_GET";
var result = MAccess.GetSavantList <MySqlConnection, Novedad>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public IEnumerable <Nomina> getNominaGrilla(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_LEGAJO", Value = param.IdLegajo
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_TIPO", Value = param.Tipo
}
};
var sqlQuery = "SP_NOMINA_GET";
var result = MAccess.GetSavantList <MySqlConnection, Nomina>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public ResponseHelper guardarConfiguracionJornadaUpd(ParamEntity <dynamic> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_JSON", Value = param.Json
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_ABM_JORNADAS_UPD";
var responseHelper = new ResponseHelper();
responseHelper = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(responseHelper);
}
public ResponseHelper guardarRegistrosHsExtras(ParamEntity <dynamic> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_JSON_INPUT", Value = param.Json
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_LIQ_HS_EXTRAS_AUT_UPD";
var responseHelper = new ResponseHelper();
responseHelper = MAccess.SavantLoad <MySqlConnection>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(responseHelper);
}
public IEnumerable <CmbEntity <long> > getListPatologias(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_LEGAJO", Value = param.IdLegajo
},
new MySqlParameter()
{
ParameterName = "P_FECHA", Value = param.FechaDate
},
new MySqlParameter()
{
ParameterName = "P_ID_PATOLOGIA", Value = param.IdPatologia
}
};
var sqlQuery = "SP_PATOLOGIAS_GET";
var result = MAccess.GetSavantList <MySqlConnection, CmbEntity <long> >(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public IActionResult updJustificacion([FromBody] ParamEntity <Justificacion> param)
{
try
{
var result = novedadBackend.updJustificacion(param);
if (result.Ok && !param.GenericEntity.Anula)
{
var paramDynamic = new ParamEntity <dynamic>();
paramDynamic.IdEmpresa = param.IdEmpresa;
paramDynamic.IdLegajo = param.IdLegajo;
paramDynamic.FechaDateArray = new DateTime[2];
paramDynamic.FechaDateArray[0] = param.FechaDateArray[0];
paramDynamic.FechaDateArray[1] = param.FechaDateArray[1];
paramDynamic.IdPatologia = param.IdPatologia;
paramDynamic.IdUsuario = param.IdUsuario;
var resultPatologia = novedadBackend.guardarPatologiaIncidencia(paramDynamic);
return(Ok(resultPatologia));
}
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult guardarIncidencia([FromBody] ParamEntity <Novedad> param)
{
try
{
var result = novedadBackend.guardarIncidencia(param);
if (result.Ok)
{
var resultObservacion = novedadBackend.guardarObservacionIncidencia(param);
if (resultObservacion.Ok && param.IdPatologia != -1)
{
var paramDynamic = new ParamEntity <dynamic>();
paramDynamic.IdEmpresa = param.IdEmpresa;
paramDynamic.IdLegajo = param.IdLegajo;
paramDynamic.FechaDateArray = new DateTime[2];
paramDynamic.FechaDateArray[0] = param.FechaDateArray[0];
paramDynamic.FechaDateArray[1] = param.FechaDateArray[1];
paramDynamic.IdPatologia = param.IdPatologia;
paramDynamic.IdUsuario = param.IdUsuario;
var resultPatologia = novedadBackend.guardarPatologiaIncidencia(paramDynamic);
return(Ok(resultPatologia));
}
}
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
//GET
public ResponseHelper GetAbmGeneral(ParamEntity <object> param)
{
var parametros = new List <object>()
{
new MySqlParameter()
{
ParameterName = "P_ID_EMPRESA", Value = param.IdEmpresa
},
new MySqlParameter()
{
ParameterName = "P_ID_USUARIO", Value = param.IdUsuario
},
new MySqlParameter()
{
ParameterName = "P_RESULT", MySqlDbType = MySqlDbType.Int32, Direction = ParameterDirection.Output
},
new MySqlParameter()
{
ParameterName = "P_MENSAJE", MySqlDbType = MySqlDbType.VarChar, Direction = ParameterDirection.Output
}
};
var sqlQuery = "SP_ABM_GENERAL_GET";
var result = MAccess.GetSavantDataHelper <MySqlConnection, Configuracion>(sqlQuery, CommandType.StoredProcedure, typeof(MySqlParameterCollection), parametros);
return(result);
}
public ResponseHelper guardarRegistrosHsExtras(ParamEntity <dynamic> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarRegistrosHsExtras(param);
return(responseHelper);
}
public ResponseHelper guardarJornadasProgramadasUpd(ParamEntity <dynamic> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarJornadasProgramadasUpd(param);
return(responseHelper);
}
/// <summary>
/// 获取基本参数信息
/// </summary>
public ParamEntity GetParam(string id)
{
SQLiteParameter[] parms = { new SQLiteParameter("@id", DbType.String) };
parms[0].Value = id;
ParamEntity param = null;
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SqliteCommands.Registry_Get_Param, conn)) {
command.Parameters.AddRange(parms);
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
if (rdr.Read())
{
var json = SqlTypeConverter.DBNullStringHandler(rdr["json"]);
param = new ParamEntity {
Id = SqlTypeConverter.DBNullStringHandler(rdr["id"]),
Name = SqlTypeConverter.DBNullStringHandler(rdr["name"]),
Json = string.IsNullOrWhiteSpace(json) ? null : JsonConvert.DeserializeObject <ParamModel>(json),
Time = SqlTypeConverter.DBNullDateTimeHandler(rdr["time"])
};
}
}
}
}
return(param);
}
public ResponseHelper updVacacion(ParamEntity <Vacacion> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.updVacacion(param);
return(responseHelper);
}
public ActionResult Edit(int paramId)
{
ParamEntity param = ParamRepository.Instance.GetById(paramId);
param.GameId = CurrentFirm.ExternalId;
return(PartialView("_edit", param));
}
public ResponseHelper anularAviso(ParamEntity <Aviso> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.anularAviso(param);
if (!responseHelper.Ok)
{
responseHelper.Mensaje = "Hubo un problema al guardar los datos";
}
return(responseHelper);
}
public ResponseHelper guardarJornadaHabitual(ParamEntity <JornadaHabitual> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarJornadaHabitual(param);
if (!responseHelper.Ok)
{
responseHelper.Mensaje = "Hubo un problema al guardar los datos";
}
return(responseHelper);
}
public ResponseHelper guardarMarcacion(ParamEntity <Marcacion> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarMarcacion(param);
//if (!responseHelper.Ok)
//{
// responseHelper.Mensaje = "Hubo un problema al guardar los datos";
//}
return(responseHelper);
}
public ResponseHelper guardarPatologiaIncidencia(ParamEntity <dynamic> param)
{
var responseHelper = new ResponseHelper();
responseHelper = novedadDataAccess.guardarPatologiaIncidencia(param);
if (!responseHelper.Ok)
{
responseHelper.Mensaje = "Hubo un problema al guardar los datos";
}
return(responseHelper);
}
public IActionResult guardarConfiguracionJornadaUpd([FromBody] ParamEntity <dynamic> param)
{
try
{
var result = novedadBackend.guardarConfiguracionJornadaUpd(param);
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult guardarRegistrosHsExtras([FromBody] ParamEntity <dynamic> param)
{
try
{
var result = novedadBackend.guardarRegistrosHsExtras(param);
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult updVacacion([FromBody] ParamEntity <Vacacion> param)
{
try
{
var result = novedadBackend.updVacacion(param);
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
