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