public int ObtenerOidByDocumentoIdentidad(string num_docu_iden)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[2];
sqlParameters[0] = new MySqlParameter("?p_num_docu_iden", num_docu_iden);
sqlParameters[1] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Comensal_OidByDocumentoIdentidad", sqlParameters);
return(result);
}
public int ValidarIdentificacionComedor(string num_iden_come)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[2];
sqlParameters[0] = new MySqlParameter("?p_num_iden_come", num_iden_come);
sqlParameters[1] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Comensal_ValidarIdentificacionComedor", sqlParameters);
return(result);
}
public int ObtenerOidByIdentificador(string num_iden_come, int come_oid_come_aten)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[3];
sqlParameters[0] = new MySqlParameter("?p_num_iden_come", num_iden_come);
sqlParameters[1] = new MySqlParameter("?p_come_oid_come_aten", come_oid_come_aten);
sqlParameters[2] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Comensal_OidByIdentificador", sqlParameters);
return(result);
}
public int ValidarComensal(int oid_turn, int oid_come)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[3];
sqlParameters[0] = new MySqlParameter("?p_oid_turn", oid_turn);
sqlParameters[1] = new MySqlParameter("?p_oid_come", oid_come);
sqlParameters[2] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Comensal_ValidarComensal", sqlParameters);
return(result);
}
public int ValidarAtecionByFechaTipoServicio(int oid_proy, string cod_tipo_serv, string val_fech_aten, int oid_come)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[5];
sqlParameters[0] = new MySqlParameter("?p_oid_proy", oid_proy);
sqlParameters[1] = new MySqlParameter("?p_cod_tipo_Serv", cod_tipo_serv);
sqlParameters[2] = new MySqlParameter("?p_val_fech_aten", val_fech_aten);
sqlParameters[3] = new MySqlParameter("?p_oid_come", oid_come);
sqlParameters[4] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Valorizacion_ValidarAtencionByFechaTipoServicio", sqlParameters);
return(result);
}
public int ValidarTurno(TurnoBE oTurnoBE)
{
dbConnectionMySql oDB = new dbConnectionMySql();
MySqlParameter[] sqlParameters = new MySqlParameter[6];
sqlParameters[0] = new MySqlParameter("?p_proy_oid_proy", oTurnoBE.proy_oid_proy);
sqlParameters[1] = new MySqlParameter("?p_come_oid_come", oTurnoBE.come_oid_come);
sqlParameters[2] = new MySqlParameter("?p_tise_cod_tipo_serv", oTurnoBE.tise_cod_tipo_serv);
sqlParameters[3] = new MySqlParameter("?p_lect_oid_lect", oTurnoBE.lect_oid_lect);
sqlParameters[4] = new MySqlParameter("?p_val_fech", oTurnoBE.val_fech);
sqlParameters[5] = new MySqlParameter("?p_val_resu", MySqlDbType.Int32, 11, ParameterDirection.Output, true, 0, 0, null, DataRowVersion.Current, null);
int result;
result = oDB.Output_Int_SP("sp_Turno_Validar_Ins", sqlParameters);
return(result);
}
