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